Message-ID: <9B7D4396307CD311809A00500415EB405FE1E9@BKMAIL>
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
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"

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