problem with array query
| От | Grant Maxwell |
|---|---|
| Тема | problem with array query |
| Дата | |
| Msg-id | 858C4168-CAD0-4237-AAD1-C989E2CE3B45@maxan.com.au обсуждение исходный текст |
| Ответы |
Re: problem with array query
Re: problem with array query |
| Список | 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
В списке pgsql-general по дате отправления: