Re: XID Data Types

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: Ericson Smith <eric(at)did-it(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: XID Data Types
Date: 2004-05-03 18:36:33
Message-ID: 054d90pgji856h5bh227u8aodmehn5vvfl@email.aon.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 03 May 2004 13:38:45 -0400, Ericson Smith <eric(at)did-it(dot)com>
wrote:
>didit=# select *,xmin from settings where xmin > '187167023'::xid limit 5;
>ERROR: operator does not exist: xid > xid

There might be better solutions, but when I ran into the same problem,
the age(xid) function helped at lot.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A Palmblad 2004-05-03 19:48:19 C Functions, datatypes
Previous Message Steve Atkins 2004-05-03 18:25:17 Re: Per-session data?