Re: [GENERAL] Passing NULL values in dblink function call

2016-10-28 Thread Attila Kiss
    -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

Re: [GENERAL] Passing NULL values in dblink function call

2016-10-27 Thread Jaisingkar, Piyush
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

[GENERAL] Passing NULL values in dblink function call

2016-10-27 Thread Jaisingkar, Piyush
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