From: Ingram, Bryan <BIngram@sixtyfootspider.com>
To: mig@utdt.edu
Cc: pgsql-sql@postgresql.org
Subject: RE: Threaded Records in SQL: Advice Needed
Date: Tue, 11 Apr 2000 14:57:00 -0500
Message-ID: <9B7D4396307CD311809A00500415EB405FE1E9@BKMAIL> (raw)
Thanks for the ideas on the functions, that'll work nicely.
The only other problem I see in actually implementing this, is that the id
column i.e. /25/10/2/ will not be ordered correctly because it relies on
ascii values. You get alphabetic orderings, rather than numerical.
Such as:
1
10
11
12
14
2
20
25
3
4
5
instead of
1
2
3
4
5
10
11
12
14
20
25
Any ideas how to get around this? I'm working on the problem right now, but
haven't found anything yet.
Bryan
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: BIngram@sixtyfootspider.com, mig@utdt.edu
Subject: RE: Threaded Records in SQL: Advice Needed
In-Reply-To: <9B7D4396307CD311809A00500415EB405FE1E9@BKMAIL>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox