-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of alecinvan
Sent: Thursday, September 04, 2014 6:28 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] how to pass tablename to a function
Hi, All
I like to pass
Hi, All
I like to pass the tablename to function but not using execute clause, here is
my script
CREATE OR REPLACE FUNCTION functions.pgsql_event_unpack_batch(IN
_tbl text, IN jobid bigint, IN jobtime timestamp with time zone, IN
startid bigint, IN stopid bigint)
RETURNS TABLE(events
On 09/04/2014 04:42 PM, A L. wrote:
Hi, All
I like to pass the tablename to function but not using execute clause,
here is my script
CREATE OR REPLACE FUNCTION functions.pgsql_event_unpack_batch(IN _tbl
text, IN jobid bigint, IN jobtime timestamp with time zone, IN startid
bigint, IN stopid
alecinvan wrote
I like to pass the tablename to function but not using execute clause,
here is my script
[...]
I want to pass the _tbl to the select query integrated in the unpacking(),
how can I make it?
There is no way to perform a query with an unknown, at design time,
identifier
Hi, All
I like to pass the tablename to function but not using execute clause, here
is my script
CREATE OR REPLACE FUNCTION functions.pgsql_event_unpack_batch(IN _tbl text,
IN jobid bigint, IN jobtime timestamp with time zone, IN startid bigint, IN
stopid bigint)
RETURNS TABLE(events bigint,