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: (view raw, whole thread or download thread mbox)
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
for detailed examples and templates

In response to


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-2018 The PostgreSQL Global Development Group