| From: | Michael McCarthy <michael(at)tcsi(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 22:10:04 |
| Message-ID: | Pine.GSO.3.96.1000411150722.24886E-100000@sanmarino.tcsi.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Would it be too obvious to mention that leading zeroes would give you what
you need?
//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\
Michael McCarthy TCSI Corporation
michael(at)tcsi(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | tjk@tksoft.com | 2000-04-11 22:32:39 | Re: Threaded Records in SQL: Advice Needed |
| Previous Message | mig | 2000-04-11 21:13:03 | Re: Threaded Records in SQL: Advice Needed |