Function for dealing with xlog data - Mailing list pgsql-hackers

From Magnus Hagander
Subject Function for dealing with xlog data
Date
Msg-id AANLkTinE2+CMxTscP1SP3RSL7Z=v2gR42F_CcSYVZr2G@mail.gmail.com
Whole thread Raw
Responses Re: Function for dealing with xlog data  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Currently, a number of functions return data in a really
calculation-unfriendly format, e.g:

postgres=# select * from pg_current_xlog_location();pg_current_xlog_location
--------------------------0/3013158
(1 row)

It would be very useful to have a way to convert this to a bigint - so
we can do differences between different values easily. And it's AFAIUI
easily converted to a 64-bit integer.

Would others find this useful as well?

What's the best way of doing it? Should we have a function that takes
text as input, or should the functions in question be made to return a
new datatype that could then be casted?

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/


pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: system views for walsender activity
Next
From: Itagaki Takahiro
Date:
Subject: Re: system views for walsender activity