Out of curiosity, does SyBase allow you to qualify it with schema.table.column? -- Rod Taylor
This message represents the official view of the voices in my head ----- Original Message ----- From: "Vince Vielhaber" <[EMAIL PROTECTED]> To: "Rod Taylor" <[EMAIL PROTECTED]> Cc: "Peter Eisentraut" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, March 14, 2002 9:39 AM Subject: Re: [HACKERS] insert statements > On Thu, 14 Mar 2002, Rod Taylor wrote: > > > As snipped from: > > http://archives.postgresql.org/pgsql-bugs/2000-10/msg00030.php (All > > my stuff is in paper form) > > What's your definition of "other dbs"? The above statement is quite > > clearly in violation of the SQL92 and SQL99 specifications: > > And nowhere does it say that <column name> cannot be qualified with > the table name in front of it. Looking at the entire message noted > above the list of other dbs that support it is now Oracle, Sybase, > MS-SQL and mysql. If "other dbs" ends up the equivilent of "everything > but PostgreSQL" then which one is non-standard? > > > > > > > > <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 > > -- > > Rod Taylor > > > > This message represents the official view of the voices in my head > > > > ----- Original Message ----- > > From: "Vince Vielhaber" <[EMAIL PROTECTED]> > > To: "Rod Taylor" <[EMAIL PROTECTED]> > > Cc: "Peter Eisentraut" <[EMAIL PROTECTED]>; > > <[EMAIL PROTECTED]> > > Sent: Thursday, March 14, 2002 9:08 AM > > Subject: Re: [HACKERS] insert statements > > > > > > > On Thu, 14 Mar 2002, Rod Taylor wrote: > > > > > > > Why not send in your changes to PostNuke along with the > > appropriate > > > > section from the SQL specs? > > > > > > > > Surely they'll apply a reasoned patch which improves conformance > > to > > > > the SQL standard and doesn't break anything in the process. I'd > > > > suspect both SyBase, and MySQL can also take insert into foo (a) > > as > > > > well. > > > > > > Look below, I showed both syntaxes with Sybase. Since I don't have > > a > > > copy of the SQL specs I can't send them the appropriate section or I > > > would have already. Care to forward that appropriate section? > > > > > > > > > > -- > > > > Rod Taylor > > > > > > > > This message represents the official view of the voices in my head > > > > > > > > ----- Original Message ----- > > > > From: "Vince Vielhaber" <[EMAIL PROTECTED]> > > > > To: "Peter Eisentraut" <[EMAIL PROTECTED]> > > > > Cc: <[EMAIL PROTECTED]> > > > > Sent: Thursday, March 14, 2002 8:29 AM > > > > Subject: Re: [HACKERS] insert statements > > > > > > > > > > > > > On Wed, 13 Mar 2002, Peter Eisentraut wrote: > > > > > > > > > > > Vince Vielhaber writes: > > > > > > > > > > > > > For example: > > > > > > > > > > > > > > insert into foo(foo.a) values(1); > > > > > > > > > > > > > > fails because the table name is used. Update statements > > also > > > > include the > > > > > > > table name. Both fail. Does anyone know of a workaround? > > > > > > > > > > > > Completely loudly to whomever wrote that SQL. It's completely > > > > > > non-standard. > > > > > > > > > > > > (The implication I'm trying to make is that there's no way to > > make > > > > > > PostgreSQL accept that statement. Adding this as an extension > > has > > > > been > > > > > > rejected in the past.) > > > > > > > > > > I'm now wondering why it was rejected. I couldn't try this last > > > > nite > > > > > so I just tried it now. Here's with Sybase 11.0.3.3 : > > > > > > > > > > 1> create table foo(a int) > > > > > 2> go > > > > > 1> insert into foo(a) values(1) > > > > > 2> go > > > > > (1 row affected) > > > > > 1> insert into foo(foo.a) values(2) > > > > > 2> go > > > > > (1 row affected) > > > > > 1> > > > > > > > > > > And I suspect more than just mysql and sybase accept either > > syntax. > > > > > Right now I'm modifying postnuke but that's only a short term > > > > solution, > > > > > and I wouldn't want to add it to PostgreSQL either 'cuze if it > > > > remains > > > > > rejected that would hamper upgrades. ROCK --> ME <-- HARD PLACE > > > > :) > > > > > There are really no other decent CMSs available that support > > > > PostgreSQL. > > > > > > > > > > Vince. > > > > > -- > > > > > > > > > > > ====================================================================== > > > > ==== > > > > > Vince Vielhaber -- KA8CSH email: [EMAIL PROTECTED] > > > > http://www.pop4.net > > > > > 56K Nationwide Dialup from $16.00/mo at Pop4 Networking > > > > > Online Campground Directory > > http://www.camping-usa.com > > > > > Online Giftshop Superstore > > http://www.cloudninegifts.com > > > > > > > > > > > ====================================================================== > > > > ==== > > > > > > > > > > > > > > > > > > > > > > > > > ---------------------------(end of > > > > broadcast)--------------------------- > > > > > TIP 6: Have you searched our list archives? > > > > > > > > > > http://archives.postgresql.org > > > > > > > > > > > > > > > > > > > > > > Vince. > > > -- > > > > > ====================================================================== > > ==== > > > Vince Vielhaber -- KA8CSH email: [EMAIL PROTECTED] > > http://www.pop4.net > > > 56K Nationwide Dialup from $16.00/mo at Pop4 Networking > > > Online Campground Directory http://www.camping-usa.com > > > Online Giftshop Superstore http://www.cloudninegifts.com > > > > > ====================================================================== > > ==== > > > > > > > > > > > > > > > > > > > Vince. > -- > ====================================================================== ==== > Vince Vielhaber -- KA8CSH email: [EMAIL PROTECTED] http://www.pop4.net > 56K Nationwide Dialup from $16.00/mo at Pop4 Networking > Online Campground Directory http://www.camping-usa.com > Online Giftshop Superstore http://www.cloudninegifts.com > ====================================================================== ==== > > > > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
