Re: Table name as parameter

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(dot)klaver(at)gmail(dot)com