Hi,
Is there any way to persuade postgresql to sort a VARCHAR column in numeric
order first, and then text order?
e.g
1, 2, 3, 10, 20, 25, 30, 40
instead of:
1, 10, 2, 20, 25, 3, 30, 40
From looking at the docs it seems that sort order is determined by the
locale settings. Is this right, and would setting my locale to en_US cause
postgres to use a different sort order?
thanks,
ben
--
ben ausden