| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com> |
| Cc: | Sebastien FLAESCH <sf(at)4js(dot)com>, pgsql-general(at)postgresql(dot)org, mmoncure(at)gmail(dot)com |
| Subject: | Re: INTERVAL SECOND limited to 59 seconds? |
| Date: | 2009-06-07 19:28:30 |
| Message-ID: | 17203.1244402910@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com> writes:
> Looks like the original questions from the thread
> got resolved, but I found this behaviour surprising:
> regression=# select interval '1' day to second;
> interval
> ----------
> @ 1 hour
> (1 row)
> Should this be 1 second?
That is a bit odd, especially seeing that eg. '1' hour to second
comes out as 1 second. What's making it do that?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gauthier, Dave | 2009-06-08 02:19:43 | Server admin for Clients ? |
| Previous Message | Ron Mayer | 2009-06-07 18:59:14 | Re: INTERVAL SECOND limited to 59 seconds? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2009-06-07 20:08:32 | Re: Partial vacuum versus pg_class.reltuples |
| Previous Message | Stefan Kaltenbrunner | 2009-06-07 19:25:59 | Re: pg_migrator issue with contrib |