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 > > <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?
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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster