| From: | "Hartman, Matthew" <Matthew(dot)Hartman(at)krcc(dot)on(dot)ca> |
|---|---|
| To: | "Clark Slater" <pg(at)slatech(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: filter duplicates by priority |
| Date: | 2009-07-14 15:30:38 |
| Message-ID: | 366642367C5B354197A1E0D27BC175BD022598BE@KGHMAIL.KGH.ON.CA |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of Clark Slater
> Sent: Tuesday, July 14, 2009 10:04 AM
> Subject: [GENERAL] filter duplicates by priority
Maybe I'm missing something, but why not something like (incoming
pseudo-SQL):
Select part_number, max(priority)
From (
Select part_number, priority from TableAndCriteria
Union all
Select part_number, priority from TableAndCriteria
Union all
Select part_number, priority from TableAndCriteria
) as allTables
Group by part_number
Matthew Hartman
Programmer/Analyst
Information Management, ICP
Kingston General Hospital
.now.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-07-14 15:48:56 | Re: filter duplicates by priority |
| Previous Message | Greg Sabino Mullane | 2009-07-14 15:29:44 | Re: prepared statements and DBD::Pg |