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 |
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 |