Re: UNION and array types - Mailing list pgsql-general

From Scott Lamb
Subject Re: UNION and array types
Date
Msg-id 3DDEC01A.8020001@slamb.org
Whole thread Raw
In response to Re: UNION and array types  (Eric B.Ridge <ebr@tcdi.com>)
List pgsql-general
Eric B.Ridge wrote:
> I suppose it's faster too since UNION ALL doesn't try to sort?

Should be. Better to use "union all" when the implicit distinct
operation is unnecessary.

Scott


pgsql-general by date:

Previous
From: Frank Bax
Date:
Subject: Re: index vs seqscan question
Next
From: Jesus Rios
Date:
Subject: Re: COMAND TO ADD NEW USER TO MY DATABASE????