"Gauthier, Dave" <dave.gauthier@xxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
