request for sql3 compliance for the update command

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема request for sql3 compliance for the update command
Дата
Msg-id 1045654551.19508.207.camel@inspiron.cramers
обсуждение исходный текст
Ответ на \copy in Current CVS  (Teodor Sigaev <teodor@stack.net>)
Ответы Re: request for sql3 compliance for the update command  (Peter Eisentraut <peter_e@gmx.net>)
Re: request for sql3 compliance for the update command  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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@fastcrypt.com>
Cramer Consulting



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Hard problem with concurrency
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Bytea misconceptions