Re: insert statements - Mailing list pgsql-hackers

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:
         <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@michvhf.com>
To: "Rod Taylor" <rbt@zort.ca>
Cc: "Peter Eisentraut" <peter_e@gmx.net>;
<pgsql-hackers@postgreSQL.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@michvhf.com>
> > To: "Peter Eisentraut" <peter_e@gmx.net>
> > Cc: <pgsql-hackers@postgreSQL.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@michvhf.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@michvhf.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
>
======================================================================
====
>
>
>
>