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

From Christopher Browne
Subject Re: Natural ordering in postgresql? Does it exist?
Date
Msg-id 31vbgiF3fp2ofU4@individual.net
Whole thread Raw
In response to Natural ordering in postgresql? Does it exist?  ("Clark Endrizzi" <clarkendrizzi@hotmail.com>)
List pgsql-general
Quoth clarkendrizzi@hotmail.com ("Clark Endrizzi"):
> 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).
>
> I'm writing an application in PHP that connects to Postgres and while
> I know that PHP has some powerful natural ordering functions it would
> be much easier if I could just use something from postgres directly.
> Does there exist any way to order naturally?

If you wish to impose an ordering on an SQL query, you must specify
that ordering using an "ORDER BY" clause.

That's not a PostgreSQL issue; that's how SQL works.
--
output = ("cbbrowne" "@" "gmail.com")
http://linuxfinances.info/info/linux.html
Rules of the Evil Overlord #204. "I will hire an entire squad of blind
guards.   Not only  is this  in  keeping with  my status  as an  equal
opportunity employer, but it will  come in handy when the hero becomes
invisible or douses my only light source."
<http://www.eviloverlord.com/>

pgsql-general by date:

Previous
From: Christopher Browne
Date:
Subject: Re: Postgres 8 and Slony-1
Next
From: Ron Peterson
Date:
Subject: Re: trouble with on insert rule via libpg-perl