In article <482E80323A35A54498B8B70FF2B8798003E5AC7099@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>, "Gauthier, Dave" <dave.gauthier@xxxxxxxxx> writes: > I have a temp table containg wildcarded strings and I want to select values > froma different table using ?like? against all those wildcarded values. Here?s > the example... > create temporary table match_these (val varchar(32)); > insert into match_these (val) values (?jo%?); > insert into match_these (val) values (?%denn_?); > insert into match_these (val) values (?alt%?); > create table footable (name varchar(32)); > (insert a bunch of records) > Now... > 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) Why don't you use a simple join? Something like SELECT f.name FROM footable f JOIN match_these m ON f.name ~~ m.val -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
