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

Groups > comp.databases.postgresql > #669

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

Show all headers | View raw

Hi,

Am 03.06.2015 um 09:55 schrieb gargoyle60:
> 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 ?

Well, no I havn't.

> You could execute the returned SQL code and find a way to display it first.
>


I am now found a way, to do it (but I don't like it that way).

Inside the same sql-script-file I am now writing:

********************
CREATE OR REPLACE FUNCTION rating_overview_horizontal()
   RETURNS varchar
    AS
$$
declare
     dynamicSQLstring varchar;
BEGIN

	SELECT 
mypivotcode('rating_overview_temp','user_Info','task_title','Task_Solution_Info','varchar') 
into dynamicSQLstring;
	
	EXECUTE 'PREPARE do_something AS '|| dynamicSQLstring;

	return dynamicSQLstring;

END;
$$
LANGUAGE plpgsql;


SELECT rating_overview_horizontal();
EXECUTE do_something;
DEALLOCATE PREPARE do_something;
********************

Best regards,
Robert

Back to comp.databases.postgresql | Previous | Next — Previous 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