On 2/24/2005 10:17 PM, David Parker wrote:

> This seems to work:
>  
>         idstr := xxidout(NEW.log_xid);
>         tx_id := to_number(idstr,\'9999999999\');              
> 
> but I have no idea if this is the most efficient.....

xxid is like xid, an unsigned 32bit value. In contrast to the builtin 
xid data type xxid has all required comparision operators and an 
operator class so it can be indexed.

Keep in mind that the comparision of transaction id's is a round robin 
unsigned 32bit operation that cannot be simulated with the native int4 
data type. If you just want to store them, I suggest casting them to 
xid. But if you need to actually do something with them, go and install 
the xxid data type on the other side.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #