| From: | Grant Maxwell <grant(dot)maxwell(at)maxan(dot)com(dot)au> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | problem with array query |
| Date: | 2009-09-28 01:27:54 |
| Message-ID: | 858C4168-CAD0-4237-AAD1-C989E2CE3B45@maxan.com.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-09-28 01:42:58 | Re: problem with array query |
| Previous Message | Scott Marlowe | 2009-09-28 01:22:47 | Re: PostgreSQL reads each 8k block - no larger blocks are used - even on sequential scans |