request for sql3 compliance for the update command

From: Dave Cramer <dave(at)fastcrypt(dot)com>
To: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: request for sql3 compliance for the update command
Date: 2003-02-19 11:35:51
Message-ID: 1045654551.19508.207.camel@inspiron.cramers
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I have a large customer who is converting from informix to postgres and
they have made extensive use of

update table set (col...) = ( val...)

as a first pass would it be possible to translate this in the parser to

update table set col=val

It would appear that this is SQL3 compliant

<set clause> ::=
<update target> <equals operator> <row value designator>

<update target> ::=
<object column>
| <left paren> <object column list> <right paren>

or can someone think of another way?
--
Dave Cramer <dave(at)fastcrypt(dot)com>
Cramer Consulting

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2003-02-19 11:45:11 Bytea misconceptions
Previous Message Teodor Sigaev 2003-02-19 11:00:03 \copy in Current CVS