Received: from python.kullen.rwth-aachen.de (root@python.kullen.RWTH-Aachen.DE [137.226.77.29]) by hub.org (8.9.1/8.8.8) with ESMTP id FAA15795 for ; Thu, 22 Oct 1998 05:47:33 -0400 (EDT) (envelope-from zych@python.kullen.rwth-aachen.de) Received: (from zych@localhost) by python.kullen.rwth-aachen.de (8.8.8/8.8.8) id VAA04642; Wed, 21 Oct 1998 21:54:42 +0200 Sender: zych@python.kullen.rwth-aachen.de To: pgsql-sql@postgresql.org Subject: Probs with arrays Reply-To: zych@pool.informatik.rwth-aachen.de Mime-Version: 1.0 (generated by tm-edit 7.108) Content-Type: text/plain; charset=US-ASCII From: Gregor Zych Date: 21 Oct 1998 21:54:40 +0200 Message-ID: Lines: 32 X-Mailer: Gnus v5.6.43/XEmacs 21.0 - "Poitou" 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_/'