Skip site navigation (1) Skip section navigation (2)

Re: feature suggestion

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Gregory Stark <stark(at)enterprisedb(dot)com>
Cc: Rafael Azevedo <rafael(at)webpro(dot)com(dot)br>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: feature suggestion
Date: 2007-07-31 23:18:34
Message-ID: 200707312318.l6VNIY912113@momjian.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Gregory Stark wrote:
> "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?

As far as I can see, the _feature_ is matching MySQL optional
non-standard syntax.

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

Responses

pgsql-hackers by date

Next:From: Josh BerkusDate: 2007-07-31 23:24:24
Subject: Re: Machine available for community use
Previous:From: Gregory StarkDate: 2007-07-31 23:12:06
Subject: Re: feature suggestion

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group