"Gauthier, Dave" <[email protected]> writes:
> select * from footable where name in (select val from match_these)
> ... won't work because "in" implies equality. I want something like...
> select * from footable where name like (select val from match_these)
What you need is
select * from footable where name ~~ any (select val from match_these)
It would probably be clearer to write
select * from footable where name like any (select val from match_these)
but the ANY syntax requires an operator name, so you have to write the
operator equivalent for LIKE.
regards, tom lane
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
