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

Re: TODO question

From: "Pavlo Baron" <pb(at)pbit(dot)org>
To: "Vince Vielhaber" <vev(at)michvhf(dot)com>
Cc: "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: TODO question
Date: 2001-12-27 22:54:14
Message-ID: 017501c18f29$6b3d5fe0$6500a8c0@bw1 (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
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
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?

Pavlo Baron

In response to


pgsql-hackers by date

Next:From: Tom LaneDate: 2001-12-27 23:07:07
Subject: Re: TODO question
Previous:From: Scott RoystonDate: 2001-12-27 22:28:29
Subject: Re: Implicit cast of literal in SQL statements

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