Finding five-minute interval prior to current time
I want to find the five minute interval just before the current time. So if the current time is 8:43 I want to … Read more
I want to find the five minute interval just before the current time. So if the current time is 8:43 I want to … Read more
Am trying to fetch data from remote db and insert into three local tables. Currently I have a query which is successfully getting … Read more
If I use .. WHERE UNIX_TIMESTAMP(`some_timestamp`)>NOW() in a SELECT, does this query still make use on an index, set on some_timestamp ? 1 … Read more
I have this code which was solved by Erwin: Execute dynamic INSERT ON CONFLICT DO UPDATE in plpgsql function Now I want the … Read more
I have a CLR to use the powershell to have access to the RichTextBox Object from .net. On the SQL Function I have … Read more
Server A and Server B have identical hardware and instance configurations (A is Production, B is QA). B’s DBs were restored from A’s … Read more
I would like to write a PostgreSQL stored function that essentially behaves like the stored procedures I know and love from MSSQL and … Read more
I am writing a Table Value Function, calling the function takes 10x as long as directly running the code. I traced this to … Read more
So I’m writing a large UDF in T-SQL to be used in reporting. The UDF contains quite a few common table expressions. At … Read more
This is my remote function: CREATE OR REPLACE FUNCTION public._test1() RETURNS record LANGUAGE plpgsql AS $function$ DECLARE rec record; BEGIN select 1,2 into … Read more