Horton

Re: Insane behaviour in 8.3.3

Bob Edwards <bob@cs.anu.edu.au>

View thread View on postgr.es
From: Robert Edwards <bob@cs.anu.edu.au>
To: pgsql-sql@postgresql.org
Date: 2012-06-15T07:23:43Z
Lists: pgsql-sql 
On 14/06/12 18:39, Achilleas Mantzios wrote:

> dynacom=# SELECT id from items_tmp WHERE id=1261319 AND xid=currval('xadmin_xid_seq');
>   id
> ----
> (0 rows)
> dynacom=# -- THIS IS INSANE

Have you tried:

SELECT id from items_tmp WHERE id=1261319 AND 
xid=currval('xadmin_xid_seq'::text)

or even:

SELECT id from items_tmp WHERE id=1261319 AND 
xid=currval(('xadmin_xid_seq'::text)::regclass)

Bob Edwards.