Re: problem with array query

I don't know about Postgres 8.3, but with 8.4-docs the Syntax of your
query could be

select * from tblretrain where  NOT ('ms-ap-t2-02c9' = ANY (owners));

regards
Ludwig

Grant Maxwell schrieb:
> Hi Folks
>
> According to the 8.3 docs I should be able to write:
> select * from tblretrain where   'ms-ap-t2-02c9' NOT IN   (owners);
>
> where owners is an array per the following definition
>
> CREATE TABLE tblretrain
> (
>   pkretrainid integer NOT NULL,
>   mailid integer NOT NULL,
>   train_to smallint NOT NULL,
>   owners character varying(1024)[],
>   bayes_trained boolean DEFAULT false,
>   contents text NOT NULL,
>   CONSTRAINT tblretrain_pk PRIMARY KEY (pkretrainid)
> )
>
> The problem is that it generates an error:
>
> ERROR:  array value must start with "{" or dimension information
> ********** Error **********
> ERROR: array value must start with "{" or dimension information
> SQL state: 22P02
>
> It seems as though postgres is not recognising owners as an array.
>
> Any suggestions please ?
> regards
> Grant
>
>
>