Gregory Stark wrote:
> "Rafael Azevedo" <rafael@webpro.com.br> writes:
>
> > Unstead of having to type all the insert syntax, using ("column") names, you
> > could do the same as MySQL does.
> > for example:
> >
> > INSERT INTO Table SET
> > "Field1" = 'text',
> > "Field2" = 'text';
> >
> > So it would make it easier and faster to develop applications using Postgre.
>
> I'm a bit mystified here. What exactly about this syntax is easier or faster?
> You still have to list all the column names. It looks like it would require
> just as much typing as the regular syntax, no?
>
> Or is it that you get to reuse the same string you use for doing an update?
As far as I can see, the _feature_ is matching MySQL optional
non-standard syntax.
-- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB
http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +