On 1/13/23 14:17, Ken Tanzer wrote:
On Thu, Jan 12, 2023 at 7:08 AM Tom Lane <tgl@xxxxxxxxxxxxx
<mailto:tgl@xxxxxxxxxxxxx>> wrote:
What Postgres actually stores for an interval is three fields:
months, days, and microseconds.
Is there a way to view/extract this raw data for any given interval?
(I'm asking because of an issue that came up about intervals that were
"equal but not identical.")
1) Can you provide an example?
2) I don't know how to reverse an output interval to it's input value.
Cheers,
Ken
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
