Re: Problem with WITH RECURSIVE - Mailing list pgsql-general

From Frank Millman
Subject Re: Problem with WITH RECURSIVE
Date
Msg-id 20110522095255.F1B73B5DC26@mail.postgresql.org
Whole thread Raw
In response to Problem with WITH RECURSIVE  ("Frank Millman" <frank@chagford.com>)
List pgsql-general

> -----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


pgsql-general by date:

Previous
From: "Frank Millman"
Date:
Subject: Problem with WITH RECURSIVE
Next
From: Alban Hertroys
Date:
Subject: Re: Syntax Error for "boolean('value')" Type Casting