-eredeti Üzenet-
Feladó:Jaisingkar, Piyush <piyush.jaising...@nttdata.com>
Elküldött:Csütörtök 2016.10.27 13:51
Tárgy:Re: [GENERAL] Passing NULL values in dblink function call
Címzett:Attila Kiss <kiss.att...@dardanis.hu>; pgsql-general@postgresql.org;
Thanks, that worked
Kiss [mailto:kiss.att...@dardanis.hu]
Sent: Thursday, October 27, 2016 2:24 PM
To: Jaisingkar, Piyush
Subject: RE: [GENERAL] Passing NULL values in dblink function call
Hello,
I am not sure about this, but have you tried
%L instead of %s? It seems the ''%s'' in the format method returns
Hello,
I have created two functions on two different databases connected them using
dblink.
FOLLOWING IS THE LOCAL FUNCTION:
CREATE OR REPLACE FUNCTION chdb.dblink_onlocal() RETURNS (par1 varchar,par2
varchar,par3 varchar) AS $$
DECLARE
query varchar;
r record;
BEGIN
PERFORM