Received: from bologna.nettuno.it (bologna.nettuno.it [193.43.2.1]) by hub.org (8.9.2/8.9.1) with ESMTP id LAA80953 for ; Fri, 16 Apr 1999 11:00:58 -0400 (EDT) (envelope-from jose@sferacarta.com) 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 RAA15278; Fri, 16 Apr 1999 17:00:47 +0200 (MDT) Received: from rosso.sferacarta.com (sferacarta.com) [10.20.30.5] by proxy.sferacarta.com with esmtp (Exim 2.05 #1 (Debian)) id 10YBxE-0000JM-00; Fri, 16 Apr 1999 16:59:00 +0000 Message-ID: <37175024.21E29E50@sferacarta.com> Date: Fri, 16 Apr 1999 16:58:44 +0200 From: =?iso-8859-1?Q?Jos=E9?= Soares X-Mailer: Mozilla 4.5 [it] (Win95; I) X-Accept-Language: it MIME-Version: 1.0 To: Chris Bitmead CC: pgsql-sql@postgresql.org Subject: Re: [SQL] UPDATE subselect? References: <371736C4.96C8469E@bigfoot.com> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Take a look at PostgreSQL User's Guide Chapter 10. Arrays syntax: INSERT INTO SAL_EMP VALUES ('Bill', '{10000, 10000, 10000, 10000}', '{{"meeting", "lunch"}, {}}'); José Chris Bitmead ha scritto: > What is the correct syntax for this UPDATE? > > CREATE TABLE category ( > name text, > image text, > url text, > parent oid[] > ); > update category set parent = '{0,0}' where name='slr'; > So far so good... > update category set parent[0] = (SELECT oid from mfr where > name='canon'); > ERROR: parser: parse error at or near "select" > > -- > Chris Bitmead > http://www.bigfoot.com/~chris.bitmead > mailto:chris.bitmead@bigfoot.com