Re: [GENERAL] XMIN/xid vs UNION

2004-10-29 Thread Tom Lane
Karsten Hilbert <[EMAIL PROTECTED]> writes: > 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 ? The only thing that was added in 7.2 was xid equality. There was some talk recently

Re: [GENERAL] XMIN/xid vs UNION

2004-10-29 Thread Karsten Hilbert
> 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 duplica

Re: [GENERAL] XMIN/xid vs UNION

2004-10-29 Thread Martijn van Oosterhout
Try a cast, or just use UNION ALL On Fri, Oct 29, 2004 at 04:44:37PM +0200, Karsten Hilbert wrote: > Dear all, > > some of my views are created with help of the UNION operator. > Now, I also need to include the base table XMIN system column > into those views. Which works fine (as long as I alias