Re: UNION and array types

From: Scott Lamb <slamb(at)slamb(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: UNION and array types
Date: 2002-11-22 23:39:06
Message-ID: 3DDEC01A.8020001@slamb.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jesus Rios 2002-11-23 02:07:29 Re: COMAND TO ADD NEW USER TO MY DATABASE????
Previous Message Frank Bax 2002-11-22 23:23:56 Re: index vs seqscan question

Browse pgsql-novice by date

  From Date Subject
Next Message Hugh Esco 2002-11-23 00:02:08 Re: [SQL] Problems invoking psql. Help please.
Previous Message Eric B.Ridge 2002-11-22 23:22:43 Re: UNION and array types