RE: Threaded Records in SQL: Advice Needed - Mailing list pgsql-sql

From Ingram, Bryan
Subject RE: Threaded Records in SQL: Advice Needed
Date
Msg-id 9B7D4396307CD311809A00500415EB405FE1E9@BKMAIL
Whole thread Raw
In response to Threaded Records in SQL: Advice Needed  ("Ingram, Bryan" <BIngram@sixtyfootspider.com>)
Responses Re: Threaded Records in SQL: Advice Needed  (mig@utdt.edu)
Re: Threaded Records in SQL: Advice Needed  ("tjk@tksoft.com" <tjk@tksoft.com>)
List pgsql-sql
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




pgsql-sql by date:

Previous
From: "Antonio W. Lagnada"
Date:
Subject: DBD::ODBC for Linux
Next
From: "Bahena, Dario (CAP, ITS, MX)"
Date:
Subject: SQL92 specification ....