At 07:24 PM 1/22/2008, you wrote:
Hi all,
I have created a little test database to help illustrate my situation.
CREATE TABLE categories (
id integer NOT NULL,
name character varying(255) NOT NULL,
description character varying(255),
vocabulary_id integer,
derived boolean
)
Date: Sun, 20 Jan 2008 20:01:08 -0800
From: Ryan Wallace <[EMAIL PROTECTED]>
To: pgsql-sql@postgresql.org
Subject: improvements to query with hierarchical elements
Message-ID: <[EMAIL PROTECTED]>
Greetings,
I have a complex query which I am trying to figure out the most
efficient
way of perfo
Greetings,
I have a complex query which I am trying to figure out the most efficient
way of performing.
My database is laid out as follows:
items -have_many-> events -have_many-> event_locations -have_many->
locations
also rows in the location_links table link two locations together in
