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

Re: Threaded Records in SQL: Advice Needed

From: "tjk(at)tksoft(dot)com" <tjk(at)tksoft(dot)com>
To: BIngram(at)sixtyfootspider(dot)com (Ingram Bryan)
Cc: mig(at)utdt(dot)edu, pgsql-sql(at)postgresql(dot)org
Subject: Re: Threaded Records in SQL: Advice Needed
Date: 2000-04-11 22:32:39
Message-ID: 200004112232.PAA23653@uno.tksoft.com (view raw or flat)
Thread:
Lists: pgsql-sql
Bryan,

You can numerically, even if the field is a text field,
if all fields have a number.

Just cst to an int4.

E.g. 

create table testtable (num text, num2 text);

select num from testtable order by num::int4;



Troy


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


In response to

pgsql-sql by date

Next:From: Raul ChireaDate: 2000-04-12 02:49:44
Subject: Foreign keys breaks tables permissions
Previous:From: Michael McCarthyDate: 2000-04-11 22:10:04
Subject: RE: Threaded Records in SQL: Advice Needed

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