Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id 13F78475F4E
	for <pgsql-sql@postgresql.org>; Tue, 14 May 2002 08:30:41 -0400 (EDT)
Received: from sam.on-net.net (sam.on-net.net [204.117.190.8])
	by postgresql.org (Postfix) with ESMTP id A6270476092
	for <pgsql-sql@postgresql.org>; Tue, 14 May 2002 08:23:17 -0400 (EDT)
Received: from edison (edison.base2inc.com [206.229.85.132])
	by sam.on-net.net (8.11.3/8.11.6) with SMTP id g4ECLeR02762
	for <pgsql-sql@postgresql.org>; Tue, 14 May 2002 07:21:40 -0500 (EST)
Message-ID: <020101c1fb42$3665f770$8455e5ce@edison>
From: "Frank Morton" <fmorton@base2inc.com>
To: <pgsql-sql@postgresql.org>
References: <1713675304.1021384181@andromede.reaumur.absolight.net>
	<20020514120705.DE3E91C5D@druid.net>
Subject: sort text field numerically
Date: Tue, 14 May 2002 07:23:53 -0500
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700
X-Archive-Number: 200205/135
X-Sequence-Number: 7771

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.