Skip site navigation (1) Skip section navigation (2)

RE: Threaded Records in SQL: Advice Needed

From: "Ingram, Bryan" <BIngram(at)sixtyfootspider(dot)com>
To: mig(at)utdt(dot)edu
Cc: pgsql-sql(at)postgresql(dot)org
Subject: RE: Threaded Records in SQL: Advice Needed
Date: 2000-04-11 19:57:00
Message-ID: 9B7D4396307CD311809A00500415EB405FE1E9@BKMAIL (view raw or flat)
Thread:
Lists: 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



Responses

pgsql-sql by date

Next:From: Ingram, BryanDate: 2000-04-11 20:57:35
Subject: RE: Threaded Records in SQL: Advice Needed
Previous:From: Bahena, Dario (CAP, ITS, MX)Date: 2000-04-11 19:55:26
Subject: SQL92 specification ....

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group