best method for select within all dimensions of an array

From: Jaume Teixi <teixi(at)6tems(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: best method for select within all dimensions of an array
Date: 2002-04-08 14:28:23
Message-ID: 20020408162823.4b2f5bdc.teixi@6tems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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<maxDimension; i++)
select blo where text[i] = 'bla' '

?

bests from barcelona

jaume teixi

Browse pgsql-sql by date

  From Date Subject
Next Message Christopher Kings-Lynne 2002-04-08 14:33:15 Re: JOINS and non use of indexes
Previous Message Ian Cass 2002-04-08 12:44:34 Re: JOINS and non use of indexes