Exec a text variable as select

From: Ranieri Mazili <ranieri(dot)oliveira(at)terra(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Exec a text variable as select
Date: 2007-06-18 13:14:32
Message-ID: 46768538.9070909@terra.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

Hello,

I'm creating a function that will create a select statement into a
while, this select will be stored into a text variable, after while ends
I need to execute this query stored into variable, on SQLSERVER I can do:
EXEC(text_variable)
How can I do this on Postgres?

I appreciate any help
Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2007-06-18 13:19:00 Re: Exec a text variable as select
Previous Message Merlin Moncure 2007-06-18 13:05:51 Re: What O/S or hardware feature would be useful for databases?

Browse pgsql-sql by date

  From Date Subject
Next Message A. Kretschmer 2007-06-18 13:19:00 Re: Exec a text variable as select
Previous Message Sabin Coanda 2007-06-18 07:17:19 Re: array_to_string