Re: PLpgSQL FOR IN EXECUTE question

From: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: PLpgSQL FOR IN EXECUTE question
Date: 2002-11-08 09:06:10
Message-ID: 3DCB7E81.82132F2D@rodos.fzk.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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

Browse pgsql-sql by date

  From Date Subject
Next Message Ludwig Lim 2002-11-08 09:39:32 Re: Generating a cross tab (pivot table)
Previous Message Rachel.Vaudron 2002-11-08 08:50:24 Re: Alter table