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@pool.informatik.rwth-aachen.de @~./'O o`\.~@ kommen in den
Hier arbeiten 166 Millionen Herz, /__( \___/ )__\ Garten
96 MB, ein Esel und ein Pinguin `\__`U_/'