Re: 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" <vev(at)michvhf(dot)com>
> To: "Rod Taylor" <rbt(at)zort(dot)ca>
> Cc: "Peter Eisentraut" <peter_e(at)gmx(dot)net>;
> <pgsql-hackers(at)postgreSQL(dot)org>
> 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" <vev(at)michvhf(dot)com>
> > > To: "Peter Eisentraut" <peter_e(at)gmx(dot)net>
> > > Cc: <pgsql-hackers(at)postgreSQL(dot)org>
> > > 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: vev(at)michvhf(dot)com
> > > 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: vev(at)michvhf(dot)com
> 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: vev(at)michvhf(dot)com 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
==========================================================================