| From: | Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
|---|---|
| To: | Camila Rocha <camilarrocha(at)hotmail(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: rows in order |
| Date: | 2002-10-04 13:36:12 |
| Message-ID: | Pine.LNX.4.44.0210041614570.24754-100000@matrix.gatewaynet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
How do you plan to keep your tree represented??
There are quite a few options for this.
Extensive talk has been made in this list.
Also search the archives.
Basically you can follow
- nested trees (pure sql) aproach
- Genealogical tree representation approach
(either using text to represent the path to the parent (pure sql), or
arrays)
- The contrib/tree implementation
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel: +30-10-8981112
fax: +30-10-8981877
email: achill(at)matrix(dot)gatewaynet(dot)com
mantzios(at)softlab(dot)ece(dot)ntua(dot)gr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2002-10-04 13:37:54 | Re: rows in order |
| Previous Message | Richard Huxton | 2002-10-04 13:35:52 | Re: Can Postgres cache a table in memory? |