Alvaro Herrera <alvherre@commandprompt.com> writes:
> Kristo Kaiv wrote:
>> but it seems if i want to return the result into a record i have to use it
>> with INTO clause in the end:
> Ah, you are using it in plpgsql! OK, but the explanation to the
> discrepancy is that the second INTO is not part of the SQL sentence;
> it's plpgsql only, and is parsed by its internal parser, so not really
> part of the SQL grammar.
And, in fact, the plpgsql documentation does show this usage (section
38.5.3 in devel docs, but I think the numbering has changed since 8.2).
regards, tom lane