>>> I wrote: 
> You've got a name, and you want a list of outstanding warrants for
> parties with a matching name.
 
Correction, if that was the list you wanted, you would use an inner
join, not a semijoin.  For purposes of this illustration I guess you
would be looking for a list of parties who have outstanding warrants,
not a list of the warrants themselves.
 
-Kevin

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to