On 3/25/19 1:08 PM, Antonio Gomez wrote:
This is my *remote* function:
CREATEORREPLACE FUNCTIONpublic._test1()
RETURNS record
LANGUAGE plpgsql
AS$function$
DECLARE
rec record;
BEGIN
select1,2intorec;
returnrec;
END$function$;
This is my *local* function call:
SELECTx.a, x.b
FROMdblink('conn_str', 'select public._test1();')
asx(a int ,b int);
Do not have time to spin a test up at the moment, but what happens if
you do?"
SELECT *
FROM dblink('conn_str', 'select public._test1();')
as x(a int ,b int);
This is the error thrown:
ERROR: remote query result rowtype does notmatchthe specified FROMclause
rowtype
Question:
Since DBLINK requires that I define a schema to place the function's
return items, how do I make the call to recognize a record type being
returned by the function.
Thanks!
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
