2008/2/29, Martijn van Oosterhout <kleptog@xxxxxxxxx>: > 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend