Re: insert statements - Mailing list pgsql-hackers

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
atPop4 Networking       Online Campground Directory    http://www.camping-usa.com      Online Giftshop Superstore
http://www.cloudninegifts.com
==========================================================================