Re: BUG #5982: recursive type crashes postgres - Mailing list pgsql-bugs

From Merlin Moncure
Subject Re: BUG #5982: recursive type crashes postgres
Date
Msg-id BANLkTin2ud7LiKcKCs-USkXdnKnn2b+SqA@mail.gmail.com
Whole thread Raw
In response to Re: BUG #5982: recursive type crashes postgres  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: BUG #5982: recursive type crashes postgres
List pgsql-bugs
On Fri, Apr 15, 2011 at 3:49 PM, Kevin Grittner
<Kevin.Grittner@wicourts.gov> wrote:
> I haven't seen anything which seems like a reasonable use case yet,
> myself. =A0If you were *actually* tracking turtles and their
> offspring, that would be a completely worthless data structure. =A0Is
> there really a case where a reference to the ID of an object of like
> type isn't a better solution?

There are lots of use cases for this.  I use composite types to
marshal data to the client all the time, and recursive structures are
fairly common in many classic problems.  Recursive composites fit the
bill perfectly.

merlin

pgsql-bugs by date:

Previous
From: Rikard Pavelic
Date:
Subject: Re: BUG #5982: recursive type crashes postgres
Next
From: John R Pierce
Date:
Subject: Re: BUG #5982: recursive type crashes postgres