Re: +(pg_lsn, int8) and -(pg_lsn, int8) operators - Mailing list pgsql-hackers

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