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, whole thread or download thread mbox)
Lists: pgsql-general
> Try a cast, or just use UNION ALL

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 ?

GPG key ID E4071346 @
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

In response to


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-2017 The PostgreSQL Global Development Group