Numeric Sorting

From: Chester <chester(at)hica(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: Numeric Sorting
Date: 2007-06-07 02:48:14
Message-ID: 466771EE.8080008@hica.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2007-06-07 04:30:40 Re: Numeric Sorting
Previous Message Robert Bernier 2007-06-06 23:57:03 Re: New Live CD needed