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