Postgres Pro
Downloads
Home   >   mailing lists

Re: filter duplicates by priority - Mailing list pgsql-general

From Hartman, Matthew
Subject Re: filter duplicates by priority
Date
Msg-id 366642367C5B354197A1E0D27BC175BD022598BE@KGHMAIL.KGH.ON.CA
Whole thread Raw
In response to filter duplicates by priority  ("Clark Slater" <pg@slatech.com>)
List pgsql-general
Tree view 
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.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.

pgsql-general by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: prepared statements and DBD::Pg
Next
From: Tom Lane
Date:
Subject: Re: filter duplicates by priority