> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@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.
>
Please ignore this - I have found my error.
I have just realised that I created the original table with column types of
VARCHAR(999). I deleted everything and recreated it using VARCHAR, and
everything works fine.
Sorry to waste your time.
Frank