Postgres Pro
Downloads
Home   >   mailing lists

Re: INSERT doesn't like (.) - Mailing list pgsql-bugs
From Peter Eisentraut
Subject Re: INSERT doesn't like (.)
Date
Msg-id Pine.LNX.4.21.0010091715230.856-100000@peter.localdomain
Whole thread Raw
In response to INSERT doesn't like (.)  (pgsql-bugs@postgresql.org)
List pgsql-bugs
Tree view 
> INSERT doesn't like  (<table>.<column>)

This isn't allowed by SQL and is completely useless.

         <insert statement> ::=
              INSERT INTO <insertion target>
                <insert columns and source>

         <insertion target> ::=
              <table name>

         <insert columns and source> ::=
                <from subquery>
              | <from constructor>
              | <from default>

         <from constructor> ::=
              [ <left paren> <insert column list> <right paren> ]
                [ <override clause> ]
                <contextually typed table value constructor>

         <insert column list> ::= <column name list>

         <column name list> ::=
              <column name> [ { <comma> <column name> }... ]

         <column name> ::=
                <identifier>


--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: INSERT doesn't like (.)
Next
From: Bruce Momjian
Date:
Subject: Re: Minimal patches for PostgreSQL 7.0b3 on NetBSD/alpha 1.4.1....