> -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx > [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Frank Millman > Sent: 22 May 2011 11:22 > To: pgsql-general@xxxxxxxxxxxxxx > Subject: 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general