Probs with arrays

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_/'

Browse pgsql-sql by date

  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