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

[EMAIL PROTECTED] writes:
> I'm using Dynamo connected to Postgres.  The PreparedStatement
> generated for an INSERT works on other dbs, but Postgres complains
> with a parsing error.
>  specifically:
>    INSERT into <table> (<table>.<column>) VALUES (<value>);

What's your definition of "other dbs"?  The above statement is quite
clearly in violation of the SQL92 and SQL99 specifications:

         <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>

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

         <column name> ::= <identifier>

I'm not particularly excited about supporting non-SQL variant syntaxes
that add no functionality.

                        regards, tom lane
Reply via email to
