Home > mailing lists

sort text field numerically - Mailing list pgsql-sql

From	Frank Morton
Subject	sort text field numerically
Date	May 14, 2002 11:30:42
Msg-id	020101c1fb42$3665f770$8455e5ce@edison Whole thread Raw
In response to	order by (Mathieu Arnold <mat@mat.cc>)
Responses	Re: sort text field numerically
List	pgsql-sql

Tree view

I have a table with a column called "weight" that
is a text field, but in this case, contains float values,
such as ".8" or "0.25". Might also be null.

How can I sort them in numeric order instead of
textual order? Thanks.

pgsql-sql by date:

From: juerg.rietmann@pup.ch
Date: 14 May 2002, 11:15:09
Subject: date_part, how to use

From: Mathieu Arnold
Date: 14 May 2002, 11:30:55
Subject: Re: order by

sort text field numerically - Mailing list pgsql-sql

Previous

Next