On Mon, Oct 13, 2008 at 9:29 AM, Matthew Wilson <matt@xxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
