From: Jeff Boes <jboes@nexcerpt.com>
To: Karel Zak <zakkr@zf.jcu.cz>
Cc: pgsql-sql@postgresql.org
Subject: Re: to_char() and order-by
Date: 28 Jun 2002 08:48:33 -0400
Message-ID: <1025268513.8367.2.camel@takin.private.nexcerpt.com> (raw)
In-Reply-To: <20020628095937.A13987@zf.jcu.cz>
References: <d40a65a1.0206271127.45c44b7d@posting.google.com>
<20020628095937.A13987@zf.jcu.cz>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jboes@nexcerpt.com, zakkr@zf.jcu.cz
Subject: Re: to_char() and order-by
In-Reply-To: <1025268513.8367.2.camel@takin.private.nexcerpt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox