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



Reply via email to