In article <snt102-w49402a41c6b6599f082d35a8...@phx.gbl>, James Bond <coolof...@hotmail.com> writes:
> hi, i am fairly new in postgresql, so if anyone can help me would be great > if i simply do: > select ver_no > from version > order by ver_no > the result will be something like this: > .1.3.1 > .1.3.2.5. > .1.4.1.7.12 > .1.4.11.14.7. > .1.4.3.109.1. > .1.4.8.66. > so as you can see first 3 lines are ok, but how to make 1.4.3.109 come > before 1.4.11 because the third level "3" is smaller than "11". The query SELECT ver_no FROM version ORDER BY string_to_array(ver_no, '.', '')::int[] should do what you want. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql