Re: request for sql3 compliance for the update command

> -----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.