should we add a XLogRecPtr/LSN SQL type? - Mailing list pgsql-hackers

From Andres Freund
Subject should we add a XLogRecPtr/LSN SQL type?
Date
Msg-id 20131211124143.GC24772@awork2.anarazel.de
Whole thread Raw
Responses Re: should we add a XLogRecPtr/LSN SQL type?
Re: should we add a XLogRecPtr/LSN SQL type?
Re: should we add a XLogRecPtr/LSN SQL type?
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [PATCH] Add transforms feature
Next
From: Robert Haas
Date:
Subject: Re: Extra functionality to createuser