Groups > comp.databases.postgresql > #667

How to use PL/pgsql function returned varchar for prepared statement

From	Robert Hartmann <Robert_Hartmann@gmx.net>
Newsgroups	comp.databases.postgresql
Subject	How to use PL/pgsql function returned varchar for prepared statement
Date	2015-06-02 23:21 +0200
Organization	Aioe.org NNTP Server
Message-ID	<mkl6m1$at6$1@speranza.aioe.org> (permalink)

Show all headers | View raw

Hi there,

I have an PL/pgsql function based on

http://www.cureffi.org/2013/03/19/automatically-creating-pivot-table-column-names-in-postgresql/ 


It returns a varchar containing an SQL-statement.

Well with
SELECT functionname(...);
I get the generated SQLcode displayed.

But how I can modify my SELECT-Statement so that
the generated code is not only displayed but executed?

Sadly there is no information (except on runtime)
about how many colums should be generated.

Or can I use the output from functionname
for createing a prepared statement via PREPARE ?

PREPARE cool() AS
***SELECT functionname(...);

***here something must be changed, but I have no idea.


Best regards,
Robert

Back to comp.databases.postgresql | Previous | Next — Next in thread | Find similar

Thread

How to use PL/pgsql function  returned varchar for prepared statement Robert Hartmann <Robert_Hartmann@gmx.net> - 2015-06-02 23:21 +0200
  Re: How to use PL/pgsql function  returned varchar for prepared statement gargoyle60 <gargoyle60@example.invalid> - 2015-06-03 08:55 +0100
    Re: How to use PL/pgsql function  returned varchar for prepared statement Robert Hartmann <Robert_Hartmann@gmx.net> - 2015-06-03 22:16 +0200

csiph-web