Received: from bologna.nettuno.it (bologna.nettuno.it [193.43.2.1]) by hub.org (8.8.8/8.8.8) with ESMTP id JAA00381 for ; Fri, 18 Sep 1998 09:14:37 -0400 (EDT) (envelope-from sferac@bo.nettuno.it) Received: from proxy.sferacarta.com (mail@sfcabop1.nettuno.it [193.207.10.213]) by bologna.nettuno.it (8.8.6/8.8.6/NETTuno 3.1) with ESMTP id PAA08268; Fri, 18 Sep 1998 15:13:43 +0200 (MDT) Received: from blu.sferacarta.com (mail.sferacarta.com) [10.20.30.12] by proxy.sferacarta.com with smtp (Exim 1.92 #1 (Debian)) id 0zK27Z-0005Lg-00; Fri, 18 Sep 1998 15:06:53 +0000 Date: Fri, 18 Sep 1998 15:13:37 +0200 From: Sferacarta Software X-Mailer: The Bat! (v1.017) UNREG Reply-To: Sferacarta Software Organization: Sferacarta Software Priority: Normal Message-ID: <1634.980918@bo.nettuno.it> To: pgsql-sql@hub.org, Stephen Davies CC: pgsql-hackers@postgresql.org Subject: Re: [SQL] PostgreSQL syntax question References: <199809180507.OAA32277@mustang.sdc.com.au> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit SD> The following syntax (which is legal under Oracle) does not parse under SD> PostreSQL 6.3.2. SD> update table1 set col1=(select col2 from table2 where col3='x') where col4='z'; This syntax is SQL standard but seems that PostgreSQL doesn't support "scalar subqueries" yet. I don't see this on TODO things ? What about to add it to TODO file ? Jose'