Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id AFD3147727A for ; Fri, 28 Jun 2002 08:50:31 -0400 (EDT) Mailbox-Line: From jboes@nexcerpt.com Fri Jun 28 08:50:31 2002 Received: from yapok.nexcerpt.com (unknown [65.88.171.66]) by postgresql.org (Postfix) with ESMTP id 7BE0C476741 for ; Fri, 28 Jun 2002 08:48:03 -0400 (EDT) Received: from takin.private.nexcerpt.com (zorro.nexcerpt.com [65.88.171.65]) by yapok.nexcerpt.com (8.11.6/8.11.6) with ESMTP id g5SCm4j00383; Fri, 28 Jun 2002 08:48:04 -0400 Subject: Re: to_char() and order-by From: Jeff Boes To: Karel Zak Cc: pgsql-sql@postgresql.org In-Reply-To: <20020628095937.A13987@zf.jcu.cz> References: <20020628095937.A13987@zf.jcu.cz> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 28 Jun 2002 08:48:33 -0400 Message-Id: <1025268513.8367.2.camel@takin.private.nexcerpt.com> Mime-Version: 1.0 X-Spam-Status: No, hits=-6.4 required=5.0 tests=IN_REP_TO,ORDER_STATUS version=2.30 X-Spam-Level: X-Archive-Number: 200206/387 X-Sequence-Number: 8352 On Fri, 2002-06-28 at 03:59, Karel Zak wrote: > On Thu, Jun 27, 2002 at 12:27:11PM -0700, Jeff Boes wrote: > > Perhaps this was covered in the 7.2.x release notes, but it's mystifying us: > > Please, how are data without to_char()? > > select time_link from stat_fetch > where time_link is not null > order by 1 desc limit 10; > A sample: time_link ------------------ 113.532913923264 105.676617980003 96.575364947319 96.3684740066528 95.3645260334015 84.6487939357758 83.9759339094162 78.2595579624176 78.0376229286194 76.875627040863 (10 rows) -- Jeff Boes vox 616.226.9550 ext 24 Database Engineer fax 616.349.9076 Nexcerpt, Inc. http://www.nexcerpt.com ...Nexcerpt... Extend your Expertise