Re: request for sql3 compliance for the update command

On Wed, Feb 19, 2003 at 07:31:35AM -0500, Dave Cramer wrote:
> 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
> 
>  ::=
>    
> 
>  ::=
>  
>  |   
> 
> 
> or can someone think of another way?

I don't understand the original problem. What does informix give you? A
text file full of "update table set ()=()" which you then try to feed
into postgres? In that case, why not pass said text file through a sed or
perl script first?

Cheers,

Patrick