Re: OT: seeking query help, where? - Mailing list pgsql-admin

From Bruno Wolff III
Subject Re: OT: seeking query help, where?
Date
Msg-id 20030116232943.GA28865@wolff.to
Whole thread Raw
In response to OT: seeking query help, where?  ("Tim Lynch" <admin+pgsqladmin@thirdage.com>)
List pgsql-admin
On Thu, Jan 16, 2003 at 14:15:22 -0800,
  Tim Lynch <admin+pgsqladmin@thirdage.com> wrote:
> First, sorry for the OT, flame me off-list!
>
> I'm a sysadmin being impressed into dba service. i've been getting along
> pretty well writing queries and making reports, but i've got some questions.
> suggestions for a good list/forum for help?
>
> from two tables both with email_addr columns, i want a distinct list of all
> email_addrs in one column. what i do now is select distinct on each and then
> sort -u the results.

Use the union operator.

pgsql-admin by date:

Previous
From: "Devinder K Rajput"
Date:
Subject: Re: OT: seeking query help, where?
Next
From: "Yudha Setiawan"
Date:
Subject: Do Something before Abort on Trigger ???