On Mon, Oct 13, 2008 at 9:29 AM, Matthew Wilson <[EMAIL PROTECTED]> wrote:

> Any advice?  I wonder if this is a sign of a bad design, or maybe if
> there's some nicer SQL techniques I could use.

I don't have the book in front of me at the moment, but I remember
this exact problem and a unique solution using a schema redesign
around skill sets that would return results very quickly.  The method
described in the query was referred to as "full disjunction".

http://www.elsevier.com/wps/find/bookdescription.librarians/710075/description#description
sell the problem: 17: EMPLOYMENT AGENCY PUZZLE


Sorry that I can't be of more help than this.

-- 
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

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

Reply via email to