From: | Vince Vielhaber <vev(at)michvhf(dot)com> |
---|---|
To: | Pavlo Baron <pb(at)pbit(dot)org> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: TODO question |
Date: | 2001-12-27 23:17:29 |
Message-ID: | Pine.BSF.4.40.0112271816400.36020-100000@paprika.michvhf.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(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
==========================================================================
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-12-28 00:12:59 | Re: TODO question |
Previous Message | Tom Lane | 2001-12-27 23:07:07 | Re: TODO question |