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
functions
Function/procedure to use dblink to fetch remote data and insert to multiple local tables
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
Is a query with UNIX_TIMESTAMP using indexes in mysql?
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
Pass Parameters to trigger function to execute dynamic SQL
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
SQL Function, get value to send to CLR
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
How Can the Same Query in Two Nearly Identical Instances Generate Two Different Execution Plans?
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
Untyped functions that return tables
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
Why would call to scalar function inside a Table Value Function be slower than outside the TVF?
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
SQL Server: Cannot resolve collation conflict between “Latin1_General_CI_AS” and “[garbage]”
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
PostgreSQL error: remote query result rowtype does not match the specified FROM clause rowtype, on remote function call
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
