Re: should we add a XLogRecPtr/LSN SQL type?

Bonus points if you implement a (explicit) cast to and from timestamptz :)

--
greg
On 11 Dec 2013 12:41, "Andres Freund" <andres(at)2ndquadrant(dot)com> wrote:

> Hi,
>
> There's already a couple of SQL function dealing with XLogRecPtrs and
> the logical replication work will add a couple of more. Currently each
> of those funtions taking/returning an LSN does sprintf/scanf to
> print/parse the strings. Which both is awkward and potentially
> noticeable performancewise.
>
> It seems relatively simple to add a proper type, with implicit casts
> from text, instead?
>
> Greetings,
>
> Andres Freund
>
> --
> Andres Freund http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>