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