Re: to_char() and order-by - Mailing list pgsql-sql

From Jeff Boes
Subject Re: to_char() and order-by
Date
Msg-id 1025268513.8367.2.camel@takin.private.nexcerpt.com
Whole thread Raw
In response to Re: to_char() and order-by  (Karel Zak <zakkr@zf.jcu.cz>)
List pgsql-sql
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.532913923264105.676617980003
96.57536494731996.368474006652895.364526033401584.648793935775883.975933909416278.259557962417678.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





pgsql-sql by date:

Previous
From: Chantal Ackermann
Date:
Subject: Re: creating functional index over multiple columns
Next
From: "Valerie Goodman"
Date:
Subject: Subtraction of Dates