Re: LIKE IN

On Mar 1, 2004, at 9:41 PM, Josh Berkus wrote:

> I think it would be possible to implement a "value LIKE (
> 'x%','y%','z%')" in
> postgreSQL but you'd have to get someone interested in hacking it.

Actually, this works:

select 'a' ~~ ANY (SELECT 'a' UNION SELECT 'b');

It's a little ugly, though. In 7.4, you can use this:

SELECT 'a' ~~ ANY(array['a%','b%']);

Which is slightly better. But I think I'll stick to this for now:

SELECT * from element where name LIKE 'a%' OR name LIKE 'b%';

Regards,

David