| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Mario Weilguni" <mario(dot)weilguni(at)icomedias(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: floor function in 7.3b2 |
| Date: | 2002-10-01 14:31:45 |
| Message-ID: | 21703.1033482705@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"Mario Weilguni" <mario(dot)weilguni(at)icomedias(dot)com> writes:
> I noticed that some of my queries don't work anymore because they're using
> the floor function:
> e.g.: select type, floor(date_part('epoch', dataend)) as ts from
> last_modified
> Why is floor not working anymore?
Mph. Seems we have floor(numeric) but not floor(float8), and the latter
is what you need here.
You could cast date_part's result to numeric; or perhaps you could use
trunc() which exists in both numeric and float8 flavors. It's got
different semantics for negative inputs though.
For 7.4 we should take another look at the operator/function set and
fill in this hole and any others like it.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-10-01 15:13:31 | Re: current_timestamp after queries |
| Previous Message | Mario Weilguni | 2002-10-01 14:17:01 | floor function in 7.3b2 |