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.klaver@gmail.com