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