| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org, Julius Tuskenis <julius(at)nsoft(dot)lt> |
| Subject: | Re: how to get a number of seconds in some interval ? |
| Date: | 2008-05-13 14:15:27 |
| Message-ID: | 24656.1210688127@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> writes:
> So it seems that the arbitary assumption of (1 month=30 days, and 1 day = 24 hours) has already been made in the extract function.
Right, as I said:
>> You can derive a number if you're willing to make arbitrary assumptions
>> about the relationships of the different units (as indeed extract(epoch)
>> does),
The point is that we don't want to propagate that bogus assumption
further than we have to. EXTRACT() already implies loss of information,
so it's reasonable for it to deliver a simplified view of reality, but
it doesn't follow that division should.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Lor | 2008-05-13 17:14:08 | Re: Postgres Cluster on Solaris |
| Previous Message | Travis Smith | 2008-05-13 14:04:21 | Re: EDB database link to Oracle |