Received: from iceberg.6tems.com (unknown [212.31.53.129]) by postgresql.org (Postfix) with ESMTP id 17D004758DC for ; Mon, 8 Apr 2002 10:16:20 -0400 (EDT) Received: from valley (studio.6tems.com [213.96.34.17]) (authenticated (0 bits)) by iceberg.6tems.com (8.11.1/8.11.1/IcebergMail 8.11.0-6) with ESMTP id g38Dx2P17322 for ; Mon, 8 Apr 2002 15:59:02 +0200 X-Authentication-Warning: iceberg.6tems.com: Host studio.6tems.com [213.96.34.17] claimed to be valley Date: Mon, 8 Apr 2002 16:28:23 +0200 From: Jaume Teixi To: pgsql-sql@postgresql.org Subject: best method for select within all dimensions of an array Message-Id: <20020408162823.4b2f5bdc.teixi@6tems.com> X-Mailer: Sylpheed version 0.7.4 (GTK+ 1.2.10; i386-debian-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Archive-Number: 200204/84 X-Sequence-Number: 7349 hello when selecting in a table with a text[] there's an sql command for looking all dimensions of the array something like 'where text[*] = 'bla' ' or only should be implemented trought a 'for (i=0; i