Skip site navigation (1) Skip section navigation (2)

Re: TODO question

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 (view raw or flat)
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
==========================================================================




In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2001-12-28 00:12:59
Subject: Re: TODO question
Previous:From: Tom LaneDate: 2001-12-27 23:07:07
Subject: Re: TODO question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group