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

Re: feature suggestion

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: "Rafael Azevedo" <rafael(at)webpro(dot)com(dot)br>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: feature suggestion
Date: 2007-07-31 23:12:06
Message-ID: 87sl74yxq1.fsf@oxford.xeocode.com (view raw or flat)
Thread:
Lists: pgsql-hackers
"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


In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2007-07-31 23:18:34
Subject: Re: feature suggestion
Previous:From: Bruce MomjianDate: 2007-07-31 23:02:14
Subject: Re: default_text_search_config and expression indexes

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