request for sql3 compliance for the update command - Mailing list pgsql-hackers

From Dave Cramer
Subject request for sql3 compliance for the update command
Date
Msg-id 1045657895.19508.220.camel@inspiron.cramers
Whole thread Raw
In response to \copy in Current CVS  (Teodor Sigaev <teodor@stack.net>)
Responses Re: request for sql3 compliance for the update command
List pgsql-hackers
Bruce,

Can you chime in with your support here?

Dave

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@fastcrypt.com>
Cramer Consulting



pgsql-hackers by date:

Previous
From: Kevin Brown
Date:
Subject: Re: location of the configuration files
Next
From: Felipe Schnack
Date:
Subject: psql problem in 7.2.3