Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.postgresql > #668

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

From gargoyle60 <gargoyle60@example.invalid>
Newsgroups comp.databases.postgresql
Subject Re: How to use PL/pgsql function returned varchar for prepared statement
Date 2015-06-03 08:55 +0100
Organization A noiseless patient Spider
Message-ID <jmctmad3h9f3ritl8qivevaqg5j5cftcgf@4ax.com> (permalink)
References <mkl6m1$at6$1@speranza.aioe.org>

Show all headers | View raw


On Tue, 02 Jun 2015 23:21:07 +0200, Robert Hartmann <Robert_Hartmann@gmx.net> wrote:

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

Have you considered using DBLINK ?
You could execute the returned SQL code and find a way to display it first.

Back to comp.databases.postgresql | Previous | NextPrevious in thread | 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