| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Mark Dilger <pgsql(at)markdilger(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [SQL] Interval subtracting |
| Date: | 2006-03-01 23:17:45 |
| Message-ID: | 16845.1141255065@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches pgsql-sql |
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
>> Well, the question is whether justify_days has a sane definition that is
>> different from this. Based on your example, I'm not seeing one.
> Uh, justify days only deals with days <--> months conversions. There is
> no processing for hours. I don't understand your comment.
So it won't guarantee that hours has a consistent sign. If you're OK
with that, then that's fine, let's make justify_days work that way and
then provide a justify_interval that processes all three fields.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-03-01 23:20:52 | Re: [SQL] Interval subtracting |
| Previous Message | Bruce Momjian | 2006-03-01 23:11:57 | Re: [SQL] Interval subtracting |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-03-01 23:20:52 | Re: [SQL] Interval subtracting |
| Previous Message | Bruce Momjian | 2006-03-01 23:11:57 | Re: [SQL] Interval subtracting |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-03-01 23:20:52 | Re: [SQL] Interval subtracting |
| Previous Message | Bruce Momjian | 2006-03-01 23:11:57 | Re: [SQL] Interval subtracting |