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