Re: Insert vs Update syntax - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Insert vs Update syntax
Date
Msg-id 20080229162155.GB28668@svana.org
Whole thread Raw
In response to Insert vs Update syntax  (Clodoaldo <clodoaldo.pinto.neto@gmail.com>)
Responses Re: Insert vs Update syntax
List 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@svana.org>   http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
>  -- John F Kennedy

Attachment

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: errors in pg_restore on windows?
Next
From: Steve Clark
Date:
Subject: Re: ecpg problem