Re: Natural ordering in postgresql? Does it exist?

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: "Clark Endrizzi" <clarkendrizzi(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Natural ordering in postgresql? Does it exist?
Date: 2004-12-11 00:36:22
Message-ID: 87oeh1y8l5.fsf@asmodeus.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Clark Endrizzi" <clarkendrizzi(at)hotmail(dot)com> writes:

> Hi all,
> I have a field that I'll be ordering and I noticed that ordering is
> done logically and would confuse my users here (1,12,16,4,8, etc).

Sounds like you're storing a number in a text field. Numeric fields
sort in numerical order.

-Doug

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2004-12-11 00:36:43 Re: Significado logo PostgreSQL
Previous Message elein 2004-12-11 00:19:39 Re: Significado logo PostgreSQL