| From: | Jeff Boes <jboes(at)nexcerpt(dot)com> |
|---|---|
| To: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: to_char() and order-by |
| Date: | 2002-06-28 12:48:33 |
| Message-ID: | 1025268513.8367.2.camel@takin.private.nexcerpt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Brett | 2002-06-28 13:38:11 | Re: Function question |
| Previous Message | Chantal Ackermann | 2002-06-28 11:22:02 | Re: creating functional index over multiple columns |