Postgres Pro
Downloads
Home   >   mailing lists

Re: hstore problem with UNION? - Mailing list pgsql-general

From Ivan Voras
Subject Re: hstore problem with UNION?
Date
Msg-id hs8thu$2pi$1@dough.gmane.org
Whole thread Raw
In response to Re: hstore problem with UNION?  (Jayadevan M <Jayadevan.Maymala@ibsplc.com>)
List pgsql-general
Tree view 
On 05/10/10 14:10, Jayadevan M wrote:
> When we do a union, the database has to get rid of duplicates and get
> distinct values. To achieve this, probably it does a sort. Just
> guesswork....

You are right, it looks like I have inverted the logic of UNION and
UNION ALL - I actually needed "UNION ALL" here, thanks!

pgsql-general by date:

Previous
From: Jayadevan M
Date:
Subject: Re: hstore problem with UNION?
Next
From: Andy Colson
Date:
Subject: Re: Create View from command line