[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [HACKERS] feature suggestion
From:       Bruce Momjian <bruce () momjian ! us>
Date:       2007-07-31 23:18:34
Message-ID: 200707312318.l6VNIY912113 () momjian ! us
[Download RAW message or body]

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. +

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq
[prev in list] [next in list] [prev in thread] [next in thread]