JOIN on set of rows?

[Peter Fein <pfein@xxxxxxxxx>]

Hiya-

I need to do something like this:

SELECT t1.symbol AS app_name, t2.outside_key AS app_id
FROM t2 LEFT JOIN t1 ON t1.t2_id=t2.id AS my_join
LEFT JOIN rows of arbitrary (app_name, app_id) ON
my_join.app_name=rows.app_name AND my_join.app_id=rows.app_id

The arbitrary app_name, app_id come from my app ;). I can't figure out
how to create something that acts like a table with rows specified in
the text of the query.

A temporary table perhaps?  I don't know much (anything) about these...

Thanks!

-- 
Peter Fein                 pfein@xxxxxxxxx                 773-575-0694

Basically, if you're not a utopianist, you're a schmuck. -J. Feldman

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match