Numeric Sorting - Mailing list pgsql-general

From Chester
Subject Numeric Sorting
Date
Msg-id 466771EE.8080008@hica.com.au
Whole thread Raw
Responses Re: Numeric Sorting
List pgsql-general
Hi

Just a quick one, I have been around Postgres for a little while and
have never found an answer to this.

Can you numerically sort a set of integers stored in a char column, I
guess change the cast of the column for the "sort by" process.

and, if you can how...Unfortunatly I  have no choice in  the current
"char" definition of  the column.

The version of PSQL is 8.+

TIA

Regards

C



pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Looking for Graphical people for PostgreSQL tradeshow signage
Next
From: Michael Glaesemann
Date:
Subject: Re: Numeric Sorting