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

Re: INSERT doesn't like (<table>.<column>)

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: adam_l_levine(at)hotmail(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: INSERT doesn't like (<table>.<column>)
Date: 2000-10-09 15:18:24
Message-ID: Pine.LNX.4.21.0010091715230.856-100000@peter.localdomain (view raw or flat)
Thread:
Lists: pgsql-bugs
> 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(at)gmx(dot)net       http://yi.org/peter-e/


In response to

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2000-10-09 19:54:51
Subject: Re: Minimal patches for PostgreSQL 7.0b3 on NetBSD/alpha 1.4.1....
Previous:From: Tom LaneDate: 2000-10-09 14:20:23
Subject: Re: INSERT doesn't like (<table>.<column>)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group