At 09:44 +0300 on 15/08/1999, Jan Vicherek wrote:


> Q1:  What is a good way to store this tree in ? (This is somewhat generic
> question, so it may be a good FAQ candidate.) I want SELECTs to be fast,
> and INSERTs/UPDATEs I don't care. Would making custom datatype help ? How?

About a year and a half ago, there was a book recommendation about this
issue. The book discusses advanced data structures representation with SQL.
Now that PostgreSQL has subqueries and unions, it becomes more relevant.
The book was:

Joe Celko's
SQL for Smarties
Advanced SQL Programming

The publisher:

Morgan Kaufmann Publishers, Inc
340 Pine St 6th Floor
San Francisco CA 94104-33205
USA
415-392-2665
[EMAIL PROTECTED]
http://www.mkp.com

The original poster of this recommendation was Terry Harple, and it was on
the (now defunct) QUESTIONS list.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma


Reply via email to