> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Frank Millman
> Sent: 22 May 2011 11:22
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Problem with WITH RECURSIVE
>
>
Hi all
I am running PostgreSQL 9.0.3 on Fedora 14.
I am trying to use WITH RECURSIVE on an adjacency list. It is mostly
working, but I have hit a snag.
CREATE TABLE departments (
row_id SERIAL PRIMARY KEY,
code VARCHAR NOT NULL
parent_id INT REFERENCES departments,
description VARCHAR NO
