Re: tree structure photo gallery date quiery

Поиск
Список
Период
Сортировка
От sad
Тема Re: tree structure photo gallery date quiery
Дата
Msg-id 200411161608.18040.sad@bankir.ru
обсуждение исходный текст
Ответ на tree structure photo gallery date quiery  (Gary Stainburn <gary.stainburn@ringways.co.uk>)
Ответы Re: tree structure photo gallery date quiery
Список 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 по дате отправления:

Предыдущее
От: Achilleus Mantzios
Дата:
Сообщение: Re: Move table between schemas
Следующее
От: Rod Taylor
Дата:
Сообщение: Re: tree structure photo gallery date quiery