Re: timestamp - timestamp result

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: Thomas Kellerer <shammat(at)gmx(dot)net>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: timestamp - timestamp result
Date: 2020-06-26 16:53:49
Message-ID: 19970.1593190429@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> writes:
> pá 26. 6. 2020 v 7:29 odesílatel Thomas Kellerer <shammat(at)gmx(dot)net> napsal:
>> Is it safe to assume that "timestamp - timestamp" will never contain units
>> larger then days?

> Now, this operator internally calls only interval_justify_hours functions.

We should probably document that --- I'll go do so.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brad Nicholson 2020-06-26 18:24:44 PG13 Trusted Extension usability issue
Previous Message PG Bug reporting form 2020-06-26 14:10:47 BUG #16513: Postgresql HA Cluster