Re: Print pg_lsn as a number?

2018-06-12 Thread Scott Stroupe 


> On Jun 12, 2018, at 10:39 AM, Andres Freund  wrote:
> 
> Hi,
> 
> On 2018-06-12 09:31:49 -0700, Scott Stroupe wrote:
>> According to the documentation[1], pg_lsn is a 64-bit integer that's
>> printed as two hex numbers separated by a slash, e.g. 68/1225BB70. Is
>> there a way to get the 64-bit integer in a common numeric
>> representation instead of the peculiar hex-slash-hex representation?
> 
> What do you want to do with the LSN?
> 
> Greetings,
> 
> Andres Freund


I want to put pg_lsns into a tool that only understands common numeric 
representations, to do simple math and comparisons.

Regards,
Scott

Print pg_lsn as a number?

2018-06-12 Thread Scott Stroupe 
According to the documentation[1], pg_lsn is a 64-bit integer that's printed as 
two hex numbers separated by a slash, e.g. 68/1225BB70. Is there a way to get 
the 64-bit integer in a common numeric representation instead of the peculiar 
hex-slash-hex representation?

Thanks,
Scott

[1] https://www.postgresql.org/docs/current/static/datatype-pg-lsn.html