Postgres Pro
Downloads
Home   >   mailing lists

Re: Union Query Improvement - Mailing list pgsql-general

From Tom Lane
Subject Re: Union Query Improvement
Date
Msg-id 19336.1171440188@sss.pgh.pa.us
Whole thread Raw
In response to Union Query Improvement  (Ray Bannon <bannonr@comcast.net>)
List pgsql-general
Tree view 
Ray Bannon <bannonr@comcast.net> writes:
> Any way to write this more efficiently?

UNION -> UNION ALL, perhaps?  Do you really need UNION's duplicate-row-
elimination behavior?

            regards, tom lane

pgsql-general by date:

Previous
From: Sujay Bhattacharya
Date:
Subject: Thank you for your email
Next
From: Ron Johnson
Date:
Subject: Re: Timestamp/Timezone - does this make sense?