| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marko Kreen | 2008-02-29 16:46:09 | Re: partitioning using dblink |
| Previous Message | Dan Armbrust | 2008-02-29 16:28:30 | Re: errors in pg_restore on windows? |