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

Re: Insert vs Update syntax

From: Clodoaldo <clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com>
To: "Martijn van Oosterhout" <kleptog(at)svana(dot)org>, Clodoaldo <clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com>, "PostgreSQL - General ML" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Insert vs Update syntax
Date: 2008-02-29 16:31:14
Message-ID: a595de7a0802290831y785c402ewcf9abdec00dac9e8@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
2008/2/29, Martijn van Oosterhout <kleptog(at)svana(dot)org>:
> 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.

I know about the standards and I'm not blaming postgresql. I just want
to know if it is worth to bring the the matter to some responsible
group.

Regards, Clodoaldo Pinto Neto

In response to

Responses

pgsql-general by date

Next:From: Marko KreenDate: 2008-02-29 16:46:09
Subject: Re: partitioning using dblink
Previous:From: Dan ArmbrustDate: 2008-02-29 16:28:30
Subject: Re: errors in pg_restore on windows?

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