Postgres Pro
Downloads
Home   >   mailing lists

Re: PLpgSQL FOR IN EXECUTE question - Mailing list pgsql-sql

From Christoph Haller
Subject Re: PLpgSQL FOR IN EXECUTE question
Date
Msg-id 3DCB7E81.82132F2D@rodos.fzk.de
Whole thread Raw
In response to PLpgSQL FOR IN EXECUTE question  (Christoph Haller <ch@rodos.fzk.de>)
List pgsql-sql
Tree view 
Thanks to Josh, Richard, Tom

EXECUTE ''SELECT CAST(''       || quote_ident($1)       || '' AS TEXT) AS foo FROM ''       || quote_ident($2)

and then

list := list || '', '' || this_record.foo ;

works perfectly.

Regards, Christoph

pgsql-sql by date:

Previous
From: "Rachel.Vaudron"
Date:
Subject: Re: Alter table
Next
From: Ludwig Lim
Date:
Subject: Re: Generating a cross tab (pivot table)