Received: from mustang.sdc.com.au (mustang.sdc.com.au [203.2.199.99]) by hub.org (8.8.8/8.8.8) with ESMTP id BAA23603 for ; Fri, 18 Sep 1998 01:08:08 -0400 (EDT) (envelope-from scldad@mustang.sdc.com.au) Received: from mustang.sdc.com.au (localhost [127.0.0.1]) by mustang.sdc.com.au (8.9.1a/8.9.1) with ESMTP id OAA32277 for ; Fri, 18 Sep 1998 14:37:29 +0930 Message-Id: <199809180507.OAA32277@mustang.sdc.com.au> X-Mailer: exmh version 2.0.2 24/2/98 To: pgsql-sql@hub.org Subject: PostgreSQL syntax question Date: Fri, 18 Sep 1998 14:37:28 +0930 From: Stephen Davies 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