"Rafael Azevedo" <rafael(at)webpro(dot)com(dot)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?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com