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

Re: Insert vs Update syntax

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Clodoaldo <clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com>
Cc: PostgreSQL - General ML <pgsql-general(at)postgresql(dot)org>
Subject: Re: Insert vs Update syntax
Date: 2008-02-29 16:21:55
Message-ID: 20080229162155.GB28668@svana.org (view raw or flat)
Thread:
Lists: pgsql-general
On Fri, Feb 29, 2008 at 01:17:20PM -0300, Clodoaldo wrote:
> When inserting into a table and there are many columns to be inserted
> it is hard to synchronize columns to values:

<snip>

> Is there some reason for the insert syntax to be the way it is in
> instead of the much easier to get it right Update syntax?:

Because it's what the SQL standard says. If you don't like it I suggest
you take it up with them... But it's a little late to change now I
think.

Have a nice day,
-- 
Martijn van Oosterhout   <kleptog(at)svana(dot)org>   http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
>  -- John F Kennedy

In response to

Responses

pgsql-general by date

Next:From: Steve ClarkDate: 2008-02-29 16:27:25
Subject: Re: ecpg problem
Previous:From: Tom LaneDate: 2008-02-29 16:19:20
Subject: Re: errors in pg_restore on windows?

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