On Mon, Oct 13, 2008 at 1:11 PM, Richard Broersma <richard.broersma@xxxxxxxxx> wrote: > On Mon, Oct 13, 2008 at 9:29 AM, Matthew Wilson <matt@xxxxxxxxxx> wrote: > 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". Perhaps you can try: http://pgfoundry.org/projects/fulldisjunction/ -- Jonah H. Harris, Senior DBA myYearbook.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general