| From: | "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | selecting recs based on a tmp tbl vals that are wildcarded ? |
| Date: | 2009-01-08 14:48:05 |
| Message-ID: | 482E80323A35A54498B8B70FF2B8798003E5AC7099@azsmsx504.amr.corp.intel.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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)
... but that doesn't work because the subquery returns more than one row :-(
Any elegant sql solutions out there before I brute-force a solution ?
Thanks in Advance !
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-01-08 15:03:01 | Re: selecting recs based on a tmp tbl vals that are wildcarded ? |
| Previous Message | Scott Marlowe | 2009-01-08 14:48:04 | Re: RCA for MemoryContextAlloc: invalid request size(Known Issue) |