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(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
==========================================================================