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: (view raw, whole thread or download thread mbox)
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 Vielhaber -- KA8CSH    email: vev(at)michvhf(dot)com
         56K Nationwide Dialup from $16.00/mo at Pop4 Networking
        Online Campground Directory
       Online Giftshop Superstore

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-2017 The PostgreSQL Global Development Group