Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Insert vs Update syntax
- 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: Fri, 29 Feb 2008 17:21:55 +0100
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
Attachment:
signature.asc
Description: Digital signature
- Follow-Ups:
- Re: Insert vs Update syntax
- From: Clodoaldo
- Re: Insert vs Update syntax
- References:
- Insert vs Update syntax
- From: Clodoaldo
- Insert vs Update syntax
- Prev by Date: Re: errors in pg_restore on windows?
- Next by Date: Re: ecpg problem
- Previous by thread: Insert vs Update syntax
- Next by thread: Re: Insert vs Update syntax
- Indexes: