Skip to site navigation (Press enter)

Re: [BUGS] INSERT doesn't like (.)

Peter Eisentraut Mon, 09 Oct 2000 08:07:25 -0700

> 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      [EMAIL PROTECTED]       http://yi.org/peter-e/

  • Previous message
  • View by thread
  • View by date
  • Next message
  • [BUGS] INSERT doesn't like (<table>.<column>... pgsql-bugs
    • Re: [BUGS] INSERT doesn't like (<table>.<co... Tom Lane
    • Peter Eisentraut

Reply via email to

The Mail Archive
  • The Mail Archive home
  • pgsql-bugs - all messages
  • pgsql-bugs - about the list
  • Expand
  • Previous message
  • Next message
  • The Mail Archive home
  • Add your mailing list
  • FAQ
  • Support
  • Privacy
  • Pine.LNX.4.21.0010091715230.856-100000@peter.localdomain