From: | Gregor Zych <zych(at)pool(dot)informatik(dot)rwth-aachen(dot)de> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Probs with arrays |
Date: | 1998-10-21 19:54:40 |
Message-ID: | m2r9w1g073.fsf@python.kullen.rwth-aachen.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi!
Could some kind soul look into these problems?
create table newww (
telnr text[]
);
insert into newww values (
'{{"111 11111"},{"2222 2222"}}'
);
insert into newww values (
'{{"33 33333"}}'
);
insert into newww values (
'{{"111 11111"}}'
);
I would like to search for telnr, with certain substr. How do I have
make the query.
test=> select * from newww where telnr like '{{"%1%"}}';
ERROR: There is more than one possible operator '~~' for types '_text' and 'unknown'
You will have to retype this query using an explicit cast
Ciao
Gregor
--
Gregor Zych \|/ ___ \|/ Nur die Harten
zych(at)pool(dot)informatik(dot)rwth-aachen(dot)de @~./'O o`\.~@ kommen in den
Hier arbeiten 166 Millionen Herz, /__( \___/ )__\ Garten
96 MB, ein Esel und ein Pinguin `\__`U_/'
From | Date | Subject | |
---|---|---|---|
Next Message | Aleksey Dashevsky | 1998-10-22 09:45:50 | Re: [SQL] `statistical' aggregate functions etc. |
Previous Message | Mark Wilson | 1998-10-21 13:52:04 | Large Object Interface |