> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
