Re: to_char() and order-by

Поиск
Список
Период
Сортировка
От Jeff Boes
Тема Re: to_char() and order-by
Дата
Msg-id 1025268513.8367.2.camel@takin.private.nexcerpt.com
обсуждение исходный текст
Ответ на Re: to_char() and order-by  (Karel Zak <zakkr@zf.jcu.cz>)
Список 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 по дате отправления:

Предыдущее
От: Chantal Ackermann
Дата:
Сообщение: Re: creating functional index over multiple columns
Следующее
От: "Valerie Goodman"
Дата:
Сообщение: Subtraction of Dates