| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Clark | 2008-02-29 16:27:25 | Re: ecpg problem |
| Previous Message | Tom Lane | 2008-02-29 16:19:20 | Re: errors in pg_restore on windows? |