Skip site navigation (1) Skip section navigation (2)

Re: XMIN/xid vs UNION

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: XMIN/xid vs UNION
Date: 2004-10-29 21:51:22
Message-ID: 20041029235122.P624@hermes.hilbert.loc (view raw or flat)
Thread:
Lists: pgsql-general
> Try a cast, or just use UNION ALL
Thanks.

Casting didn't work (it was missing the proper cast function
from xid to int4) but using UNION ALL worked. This was also
possible to use in my case since both parts of the UNION do
indeed return distinct sets of rows so UNION ALL does not
produce duplicates.

However, the question still holds true: Is there any
particular reason those operators aren't found in my PG
installation despite being listed as added since 7.2 ?
IOW why does
 select 1::xid::int2/int4/int8
fail (on 7.4) despite 7.2 docs suggesting it should work ?

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

In response to

Responses

pgsql-general by date

Next:From: Martijn van OosterhoutDate: 2004-10-29 21:54:05
Subject: Re: column updates
Previous:From: stig eriksonDate: 2004-10-29 21:18:48
Subject: logging queries and time used

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group