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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Fri, 29 Feb 2008 13:31:14 -0300
  • Message-id: <a595de7a0802290831y785c402ewcf9abdec00dac9e8@mail.gmail.com> <text/plain>

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



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group