On Sat, Dec 19, 2009 at 1:30 PM, Postgres User
<postgres.developer@gmail.com> wrote:
>
> Thanks, your syntax does compile and run.
>
> This is where it gets interesting. With your syntax (and variations
> of it), I'm able to successfully compile and execute. However, as
> soon as I add a dozen rows to the table, the query failes to complete.
> It runs until timing out.
> This prolem does not occur when I remove the SELECT INTO ARRAY
> statement and simply run the recursive query.
>
> Has anyone else seen this behavior?
are you sure you don't have a circular dependency? maybe you have a
variable/column name clash?
merlin