request for sql3 compliance for the update command

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема request for sql3 compliance for the update command
Дата
Msg-id 1045657895.19508.220.camel@inspiron.cramers
обсуждение исходный текст
Ответ на \copy in Current CVS  (Teodor Sigaev <teodor@stack.net>)
Ответы Re: request for sql3 compliance for the update command  (Patrick Welche <prlw1@newn.cam.ac.uk>)
Список 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 по дате отправления:

Предыдущее
От: Kevin Brown
Дата:
Сообщение: Re: location of the configuration files
Следующее
От: Felipe Schnack
Дата:
Сообщение: psql problem in 7.2.3