Received: from tech.com.au (IDENT:root@techpt.lnk.telstra.net [139.130.75.122]) by hub.org (8.9.2/8.9.1) with ESMTP id JAA59668 for ; Fri, 16 Apr 1999 09:11:14 -0400 (EDT) (envelope-from chris.bitmead@bigfoot.com) Received: from bigfoot.com (chris@localhost [127.0.0.1]) by tech.com.au (8.8.7/8.8.7) with ESMTP id XAA21339 for ; Fri, 16 Apr 1999 23:10:30 +1000 Sender: chris@tech.com.au Message-ID: <371736C4.96C8469E@bigfoot.com> Date: Fri, 16 Apr 1999 13:10:28 +0000 From: Chris Bitmead X-Mailer: Mozilla 4.51 [en] (X11; I; Linux 2.0.36 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: UPDATE subselect? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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