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 rec;
return rec;
END $function$;
This is my local function call:
SELECT x.a, x.b
FROM dblink('conn_str', 'select public._test1();')
as
is.
Thanks for your response!
--T.
-Original Message-
From: Adrian Klaver
Sent: Monday, March 25, 2019 6:14 PM
To: Antonio Gomez ; pgsql-general@lists.postgresql.org
Subject: Re: Error: "remote query result rowtype does not match the specified
FROM clause rowtype," on remote fu
