How the heck would you build an IN clause with a primary key which is
composite?

so say columns foo and bar are the primary key.

if you just had foo as your column name, you can do

where foo in ()

… but with two keys I don't see how it's possible.

specifying both actually builds a cartesian product.  which is kind of cool
but not what I want :)

-- 

Founder/CEO Spinn3r.com
Location: *San Francisco, CA*
blog: http://burtonator.wordpress.com
… or check out my Google+ profile
<https://plus.google.com/102718274791889610666/posts>
<http://spinn3r.com>

Reply via email to