On Sat, Dec 19, 2009 at 1:30 PM, Postgres User <postgres.developer@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
