best method for select within all dimensions of an array - Mailing list pgsql-sql

From Jaume Teixi
Subject best method for select within all dimensions of an array
Date
Msg-id 20020408162823.4b2f5bdc.teixi@6tems.com
Whole thread Raw
List 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


pgsql-sql by date:

Previous
From: "Ian Cass"
Date:
Subject: Re: JOINS and non use of indexes
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: JOINS and non use of indexes