Re: Selecting from table into an array var - Mailing list pgsql-general

From Merlin Moncure
Subject Re: Selecting from table into an array var
Date
Msg-id b42b73150912210723q66daee24yc55b31c06030f521@mail.gmail.com
Whole thread Raw
In response to Re: Selecting from table into an array var  (Postgres User <postgres.developer@gmail.com>)
List pgsql-general
On Sat, Dec 19, 2009 at 7:08 PM, Postgres User
<postgres.developer@gmail.com> wrote:
> Great call, someone did hose the data.  Oddly enough the circular
> reference caused no problem when running the stand alone recursive SQL
> (with clause).
>

no problem.  I would advise guarding against circular dependencies
either with a trigger on the relationship table, a recursion limit in
the query itself, or both.

merlin

pgsql-general by date:

Previous
From: Chris Ernst
Date:
Subject: Re: Extracting SQL from logs in a usable format
Next
From: Adrian Klaver
Date:
Subject: Re: import warnings ?