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-
Grant Maxwell writes:
> What I'm trying to do is find every record where "my name" is not in
> the array.
> So I tried <> ANY and also <> ALL and both returned an empty row set.
Maybe you have some nulls in the arrays? <> ALL works for me.
regards, tom lane
--
Sent v
Hi Tom
The bit I was reading is
http://www.postgresql.org/docs/8.3/interactive/arrays.html#AEN6019
__ EXTRACT
However, this quickly becomes tedious for large arrays, and is not
helpful if the size of the array is uncertain. An alternative method
is described in Section 9.20. Th
Grant Maxwell writes:
> 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
>owners character varying(1024)[],
No, what you can write is "<> ALL", not NOT IN.
> It s
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 NU
