PostgreSQL syntax question
Stephen Davies <scldad@sdc.com.au>
From: Stephen Davies <scldad@sdc.com.au>
To: pgsql-sql@hub.org
Date: 1998-09-18T05:07:28Z
Lists: pgsql-hackers
The following syntax (which is legal under Oracle) does not parse under PostreSQL 6.3.2. update table1 set col1=(select col2 from table2 where col3='x') where col4='z'; Is there a variant of the syntax which does work? Cheers and thanks, Stephen. ======================================================================== Stephen Davies Consulting scldad@sdc.com.au Adelaide, South Australia. Voice: 61-8-82728863 Computing & Network solutions. Fax: 61-8-82741015