Re: INSERT Issues - Mailing list pgsql-hackers

From Tom Lane
Subject Re: INSERT Issues
Date
Msg-id 25433.986568806@sss.pgh.pa.us
Whole thread Raw
In response to INSERT Issues  ("Rod Taylor" <rod.taylor@inquent.com>)
List pgsql-hackers
"Rod Taylor" <rod.taylor@inquent.com> writes:
> INSERT INTO table [ ( column [, ...] ) ]
>     { DEFAULT VALUES | VALUES ( expression [, ...] ) | SELECT query }

The documentation is wrong here, not the code.  SQL92 defines the syntax
as
<insert statement> ::=     INSERT INTO <table name> <insert columns and source>
<insert columns and source> ::=     [ <left paren> <insert column list> <right paren> ] <query expression>   | DEFAULT
VALUES
<insert column list> ::= <column name list>
        regards, tom lane


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Integer to float function
Next
From: Tom Lane
Date:
Subject: Re: Re: Integer to float function