Re: Selecting from table into an array var

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Postgres User <postgres(dot)developer(at)gmail(dot)com>
Cc: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Selecting from table into an array var
Date: 2009-12-21 15:23:18
Message-ID: b42b73150912210723q66daee24yc55b31c06030f521@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Dec 19, 2009 at 7:08 PM, Postgres User
<postgres(dot)developer(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message cedric.villemain 2009-12-21 15:43:21 unsubscribe
Previous Message Chris Ernst 2009-12-21 14:24:39 Re: Extracting SQL from logs in a usable format