On 2020/04/28 1:24, Robert Haas wrote:
> On Sun, Apr 26, 2020 at 9:41 PM Kyotaro Horiguchi
> <horikyota.ntt@gmail.com> wrote:
>> +1. I actually sometimes need it.
>>
>> y the way, -(pg_lsn, pg_lsn) yields a numeric.
>
> It might be a good idea to use numeric here, too. Because int8 is
> signed, it's not big enough to cover the whole range of LSNs.
Yes. Attached is the updated version of the patch, which introduces
+(pg_lsn, numeric) and -(pg_lsn, numeric) operators.
To implement them, I added also numeric_pg_lsn() function that converts
numeric to pg_lsn.
Regards,
--
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION