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

RE: Threaded Records in SQL: Advice Needed

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 (view raw or flat)
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.


In response to

pgsql-sql by date

Next:From: tjk@tksoft.comDate: 2000-04-11 22:32:39
Subject: Re: Threaded Records in SQL: Advice Needed
Previous:From: migDate: 2000-04-11 21:13:03
Subject: Re: Threaded Records in SQL: Advice Needed

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