Re: tree structure photo gallery date quiery - Mailing list pgsql-sql

From sad
Subject Re: tree structure photo gallery date quiery
Date
Msg-id 200411161608.18040.sad@bankir.ru
Whole thread Raw
In response to tree structure photo gallery date quiery  (Gary Stainburn <gary.stainburn@ringways.co.uk>)
Responses Re: tree structure photo gallery date quiery
List pgsql-sql
On Tuesday 16 November 2004 14:29, Gary Stainburn wrote:
> Hi folks.
>
> I'm looking at the possibility of implementing a photo gallery for my
> web site with a tree structure

> How would I go about creating a view to show a) the number of photos in
> a gallery and b) the timestamp of the most recent addition for a
> gallery, so that it interrogates all sub-galleries?

nested-tree helps you
associate a numeric interval [l,r] with each record of a tree
and let father interval include all its children intervals
and brother intervals never intersect

see the article http://sf.net/projects/redundantdb
for detailed examples and templates




pgsql-sql by date:

Previous
From: Achilleus Mantzios
Date:
Subject: Re: Move table between schemas
Next
From: Rod Taylor
Date:
Subject: Re: tree structure photo gallery date quiery