Gregory Stark wrote: > "Rafael Azevedo" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq