Postgres Pro
Downloads
Home   >   mailing lists

Re: Natural ordering in postgresql? Does it exist? - Mailing list pgsql-general

From Doug McNaught
Subject Re: Natural ordering in postgresql? Does it exist?
Date
Msg-id 87oeh1y8l5.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to Natural ordering in postgresql? Does it exist?  ("Clark Endrizzi" <clarkendrizzi@hotmail.com>)
List pgsql-general
Tree view 
"Clark Endrizzi" <clarkendrizzi@hotmail.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

pgsql-general by date:

Previous
From: "Ian Harding"
Date:
Subject: Re: Natural ordering in postgresql? Does it exist?
Next
From: Michael Fuhr
Date:
Subject: Re: Significado logo PostgreSQL