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>';
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