> -----Original Message----- > From: Mike Aubury [mailto:[EMAIL PROTECTED]] > 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. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
