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

Re: XMIN/xid vs UNION

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: XMIN/xid vs UNION
Date: 2004-10-29 15:52:54
Message-ID: 20041029155251.GA5482@svana.org (view raw or flat)
Thread:
Lists: pgsql-general
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 them)
> except that UNION does an internal sort. My PG version (7.4)
> complains about not being able to find a sort operator for
> data type XID (of which XMIN is).
> 
> Searching the web unearthes a solution for loading those
> missing operators for as early as 6.4.1 (1998) !
> 
>  http://archives.postgresql.org/pgsql-general/1998-11/msg00096.php
> 
> Strangely enough I see those operators listed in the release
> notes for 7.2 ...
> 
>  http://www.postgresql.org/docs/7.2/interactive/release-7-2.html
> 
> Are those operators included in PG > 7.4 ? Should they be ? Is
> it my version that's compiled without them, perhaps ?
> 
> Thanks,
> Karsten
> -- 
> GPG key ID E4071346 @ wwwkeys.pgp.net
> E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
>                http://archives.postgresql.org

-- 
Martijn van Oosterhout   <kleptog(at)svana(dot)org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

In response to

Responses

pgsql-general by date

Next:From: Thomas HallgrenDate: 2004-10-29 15:53:20
Subject: Re: Question regarding the mailing list.
Previous:From: Thomas HallgrenDate: 2004-10-29 15:48:11
Subject: Re: Question regarding the mailing list.

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