On 1/13/23 14:17, Ken Tanzer wrote:
> On Thu, Jan 12, 2023 at 7:08 AM Tom Lane <tgl@sss.pgh.pa.us
> <mailto:tgl@sss.pgh.pa.us>> 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@aklaver.com