| From: | "Frank Millman" <frank(at)chagford(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Problem with WITH RECURSIVE |
| Date: | 2011-05-22 09:52:47 |
| Message-ID: | 20110522095255.F1B73B5DC26@mail.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Frank Millman
> Sent: 22 May 2011 11:22
> To: pgsql-general(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alban Hertroys | 2011-05-22 10:22:49 | Re: Syntax Error for "boolean('value')" Type Casting |
| Previous Message | Frank Millman | 2011-05-22 09:22:24 | Problem with WITH RECURSIVE |