Hi folks,
I've got a table holding loco numbers and an id which references the locos
table. How can I sort this table, so that numeric values appear first in
numerical order followed by alpha in alpha order.?
nymr=# \d lnumbers Table "lnumbers" Column | Type | Modifiers
-----------+-----------------------+-----------lnid | integer | not nulllnumber | character
varying(10)| not nulllncurrent | boolean |
Primary key: lnumbers_pkey
Triggers: RI_ConstraintTrigger_7121182
nymr=# select * from lnumbers order by lnumber;lnid | lnumber | lncurrent
------+---------+----------- 26 | 08556 | t 13 | 08850 | f 2 | 2392 | f 15 | 24 061 | t 12 | 25 278 | f
1 | 29 | t 5 | 30926 | t 3 | 4277 | t 7 | 44767 | t 21 | 45157 | t 13 | 4518 | t 6 | 45212
|t 16 | 45337 | t 23 | 4771 | f 19 | 5 | t 24 | 55019 | t 27 | 59 | f 11 | 60007 | t 8 |
60532 | t 23 | 60800 | t 14 | 62005 | t 14 | 62012 | f 18 | 64360 | f 2 | 65894 | t 17 | 6619 | t
27| 69023 | t 9 | 75014 | t 10 | 75029 | t 22 | 76079 | t 4 | 80135 | t 20 | 825 | t 18 | 901
|t 5 | 926 | f 26 | D3723 | f 15 | D5061 | t 12 | D7628 | t 25 | D9009 | t 24 | D9019 | f
(38 rows)
nymr=#
--
Gary Stainburn
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000
