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.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
