Re: Arrays and LIKE - Mailing list pgsql-general

From Jasen Betts
Subject Re: Arrays and LIKE
Date
Msg-id h5jm23$6t2$1@reversiblemaps.ath.cx
Whole thread Raw
In response to Arrays and LIKE  (David <david@vanlaatum.id.au>)
List pgsql-general
On 2009-08-08, David <david@vanlaatum.id.au> wrote:
> Done a bit of hunting and can't seem to find an answer as to if this sort of thing is possible:
>
> SELECT * FROM mail WHERE recipients ILIKE 'david%';
>
> Where recipients is a VARCHAR(128)[]
>
> The above doesn't work but thats the sort of thing I want to do...
> If this is possible and can use an index as well that would be wonderful...

hmm tricky: you can't use any(recipients) ilike 'david%'




pgsql-general by date:

Previous
From: sweta@opspl.com
Date:
Subject: duplicate key violates unique constraint
Next
From: Jasen Betts
Date:
Subject: 'a' = any( $${'a','x'} )