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.)

Yeah, that's kinda what I expected.  There's just under 1700 insert and
update statements but only 1200 selects.  Neither option sounds good at
this point.

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