On 05/09/2011 12:33 PM, Sairam Krishnamurthy wrote:
All,
I have a function that takes the table name the parameter. After some
digging I found that this can be made possible by have the query as a
string and EXECUTE it.
EXECUTE 'SELECT * FROM "' || table || '" WHERE <condition>';
The above works.
But I want the result in a record variable for further processing. So my
query actually is
EXECUTE 'SELECT * FROM "' || table || '" INTO "record_data" WHERE
<condition>';
Try.:
EXECUTE 'SELECT * FROM "' || table || '" WHERE
<condition>' INTO record_data;
This one will not work with the following error message:
ERROR: syntax error at or near "INTO"
Can some one help me ?
Thanks,
Sairam Krishnamurthy
+1 612 859 8161
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general