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
Hello,
I currently have two functions, one on local side and one on remote.
The local function creates the dblink with all the required parameters, then
using dblink() function I call the remote function.
For the parameters of remote function I want to pass an array of records, I
create this
Hello,
I am trying to run following query in a function:
CREATE TEMP TABLE temptable on commit drop as (Select * from
unnest(string_to_array(temp1,',')) as (rep_id int,install_uprn varchar,address
text,postcode varchar));
Where temp1 is an string and looks like this:
Hello,
I am trying to run following query in a function:
CREATE TEMP TABLE temptable on commit drop as (Select * from
unnest(string_to_array(temp1,',')) as (rep_id int,install_uprn varchar,address
text,postcode varchar));
Where temp1 is an array and looks like this:
, Piyush
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Passing of where clause to remote table in FDW
"Jaisingkar, Piyush" <piyush.jaising...@nttdata.com> writes:
> While using fdw I am trying to get and filtered data from a foreign table.
> Filtering using a
Hello,
While using fdw I am trying to get and filtered data from a foreign table.
Filtering using a regex in where clause as follows:
EXPLAIN ANALYZE VERBOSE SELECT CAF1.uprn
FROM XYZ as CAF1
WHERE