On Jun 6, 2007, at 21:48 , Chester wrote:
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.
That's pretty much what you have to do, I believe.
SELECT *
FROM ints_as_chars
ORDER BY int_as_char;
int_as_char
---
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 choi
