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

From Michael McCarthy
Subject RE: Threaded Records in SQL: Advice Needed
Date
Msg-id Pine.GSO.3.96.1000411150722.24886E-100000@sanmarino.tcsi.com
Whole thread Raw
In response to RE: Threaded Records in SQL: Advice Needed  ("Ingram, Bryan" <BIngram@sixtyfootspider.com>)
List pgsql-sql
Would it be too obvious to mention that leading zeroes would give you what
you need?

//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\
Michael McCarthy                             TCSI Corporation
michael@tcsi.com                             1080 Marina Village Parkway
(510) 749-8739                               Alameda, CA 94501

> 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.



pgsql-sql by date:

Previous
From: mig@utdt.edu
Date:
Subject: Re: Threaded Records in SQL: Advice Needed
Next
From: "tjk@tksoft.com"
Date:
Subject: Re: Threaded Records in SQL: Advice Needed