Re: TEMPORARY TABLE in a PL/pgSQL function

Oh my god,
It's so simple and I'm spend a lot of time in this problem.
And the bad news for me is that this was all the time in the Postgres
Document.
Thank very much Oliver. :-)

Altought this, I want to sugest to add a session in Pl/pgSQL
documentation, a "command reference"
like the SQL commands reference with brief description of the sintax and
a link to the
proper location in atual document section for a detailed behavior.
I say this, because I think sometimes are hard to find the desired
information in the doc.

Thanks a lot.

Oliver Elphick wrote:

>On Wed, 2005-12-14 at 17:05 -0200, Luiz K. Matsumura wrote:
>
>
>>Hi, I have a similar case
>>but instead of the statement
>>PERFORM * FROM temp_table; -- without this line no problems
>>I have a SELECT INTO inside the plpgsql function
>>SELECT * INTO rec FROM temp_table;
>>That return the same error as Tjibbe got.
>>I try to use something like
>>EXEC 'SELECT * INTO rec FROM temp_table';
>>But I now postgres (8.1.1) returns a error
>>
>>EXEC of SELECT ... INTO is not implemented yet.
>>
>>
>
>You have the syntax wrong. It is:
>
> EXECUTE command-string [ INTO target ];
>
>In your case, that is:
>
> EXECUTE 'SELECT * FROM temp_table' INTO rec;
>
>so that the INTO phrase is outside the string.
>
>
>