Re: INSERT doc discrepancy - Mailing list pgsql-general

From Tom Lane
Subject Re: INSERT doc discrepancy
Date
Msg-id 29182.1188320871@sss.pgh.pa.us
Whole thread Raw
In response to Re: INSERT doc discrepancy  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: Tables dissapearing
Next
From: Tom Lane
Date:
Subject: Re: Indexing Foreign Key Columns