Re: tree structure photo gallery date quiery

From: sad <sad(at)bankir(dot)ru>
To: Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk>, pgsql-sql(at)postgresql(dot)org
Subject: Re: tree structure photo gallery date quiery
Date: 2004-11-16 13:08:17
Message-ID: 200411161608.18040.sad@bankir.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rod Taylor 2004-11-16 13:23:23 Re: tree structure photo gallery date quiery
Previous Message Achilleus Mantzios 2004-11-16 12:30:09 Re: Move table between schemas