Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group