Postgres Pro
Downloads
Home   >   mailing lists

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

From Robert Haas
Subject Re: +(pg_lsn, int8) and -(pg_lsn, int8) operators
Date
Msg-id CA+TgmobHuvqBd1SVFNQNcA=KJMKx_5wNsKTa3yqHwwqqx+wNWA@mail.gmail.com
Whole thread Raw
In response to Re: +(pg_lsn, int8) and -(pg_lsn, int8) operators  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
Responses Re: +(pg_lsn, int8) and -(pg_lsn, int8) operators  (Fujii Masao <masao.fujii@oss.nttdata.com>)
List pgsql-hackers
Tree view 
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.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: weird hash plan cost, starting with pg10
Next
From: Tom Lane
Date:
Subject: Re: weird hash plan cost, starting with pg10