Received: from tht.net (vista.tht.net [209.47.145.2]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f434eZA81671 for ; Thu, 3 May 2001 00:40:35 -0400 (EDT) (envelope-from jeff@tht.net) Received: from localhost (localhost [[UNIX: localhost]]) by tht.net (8.9.3/8.9.3) with ESMTP id AAA01513 for ; Thu, 3 May 2001 00:40:35 -0400 (EDT) Date: Thu, 3 May 2001 00:40:34 -0400 (EDT) From: Jeff MacDonald To: pgsql-sql@postgresql.org Subject: "correct" sorting. Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200105/8 X-Sequence-Number: 2806 Hi folks, say i have a text field with teh values 1,2,3,10,20,30,1a,1b,2a,2b and i want to sort it so i get, 1 1a 1b 2 2a 2b 3 10 20 30 is there anyway to do that with postgresql ? below is what actually happens. jeff=> select * from foo order by var1; var1 ------ 1 10 1a 1b 2 20 2a 2b 3 30 3a 3b (12 rows)