XID Data Types

From: Ericson Smith <eric(at)did-it(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: XID Data Types
Date: 2004-05-03 17:38:45
Message-ID: 409683A5.8040601@did-it.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello everyone,

Take the query below:

select *,xmin from settings where xmin > '187167023'::xid limit 5;

Although the docs say this is a 32 bit datatype, I have casted the
integer '187167023' also to an xid type, but it seems that there is no
operator to do a comparison, since I get this error:

didit=# select *,xmin from settings where xmin > '187167023'::xid limit 5;
ERROR: operator does not exist: xid > xid

Any pointers or suggestions?

- Ericson

Attachment Content-Type Size
eric.vcf text/x-vcard 315 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2004-05-03 17:46:41 Re: Constrint Name Length...
Previous Message Luiz Rafael Culik Guimaraes 2004-05-03 16:51:22 Fw: set autocommit TO FALSE on postgres 7.4