Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: INSERT doc discrepancy



Alvaro Herrera <alvherre(at)commandprompt(dot)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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group