Re: TODO question

On Thu, 27 Dec 2001, Pavlo Baron wrote:

> Vince Vielhaber:
> > INSERT INTO foo(a,b) values(1,2,3);
> >
>
> sorry, but I'm a little bit confused: what should or should not happen with
> this:
> if I execute this INSERT on a table having 2 cols, an error is generated:
> ERROR: INSERT has more expressions than target columns
>
> has it already been fixed? or what should be exactly disallowed? every time
> I execute such statement with any cols/vals combination having different
> cols/vals number it fails. Should it be allowed now?

Sorry, I had it backwards.

insert into foo(a,b,c) values(1,2);

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