numeric SORT order

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