

> -----Original Message-----
> From: Mike Aubury [mailto:mike@aubit.com] 
> Sent: 20 February 2003 19:10
> To: Dave Page; Tom Lane; Hannu Krosing
> Cc: Dave Cramer; Peter Eisentraut; Pgsql Hackers
> Subject: Re: [HACKERS] request for sql3 compliance for the 
> update command
> 
> 
> Informix supports 2 different styles for the update - your 
> one would have to 
> be written :
> 
> 
> UPDATE djp SET(col1, col2) = ((SELECT col1,col2 FROM 
> some_other_table))
> 
> Notice the double brackets !
> The first signifies a list of values - the second is the 
> brackets around the 
> subquery...
> 
> (NB If you try to reference the same table in the Update - 
> you'll get an 
> error....)

Ahh, of course. I tried double brackets 'cos I figured I might need one
pair to indicate the set and one to indicate the subselect, but I didn't
think to try a different table.

Regards, Dave.

Fri, 21 Feb 2003 08:10:00 -0000
"Dave Page" <dpage@vale-housing.co.uk>
Re: request for sql3 compliance for the update command