From: | Tarlika Elisabeth Schmitz <postgresql(at)numerixtechnology(dot)de> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Cc: | lennin(dot)caro(at)yahoo(dot)com |
Subject: | Re: exclude part of result |
Date: | 2008-06-27 17:40:21 |
Message-ID: | 20080627184021.7397d531@dick.coachhouse |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Fri, 27 Jun 2008 07:17:11 -0700 (PDT)
Lennin Caro <lennin(dot)caro(at)yahoo(dot)com> wrote:
>
> select * from (
> SELECT DISTINCT a, b, c, now(), count(item_pk)
> FROM product
> LEFT JOIN item ON item.product_fk = product_pk
> WHERE ...
> GROUP BY a, b, c
> ) t1 where not exists (select a,b,c, from navigation t2 where t2.a =
> t1.a and t2.b = t1.b and t2.c = t1.c)
Many thanks - there seems to be half a dozen ways of achieving the
desired result!
>
> --- On Thu, 6/26/08, Tarlika Elisabeth Schmitz
> <postgresql(at)numerixtechnology(dot)de> wrote: From: Tarlika Elisabeth
> Schmitz <postgresql(at)numerixtechnology(dot)de> Subject: [SQL] exclude part
> of result To: pgsql-sql(at)postgresql(dot)org
> Date: Thursday, June 26, 2008, 11:35 PM
>
> SELECT DISTINCT a, b, c, now(), count(item_pk)
> FROM product
> LEFT JOIN item ON item.product_fk = product_pk
> WHERE ...
> GROUP BY a, b, c
>
>
> I have another table 'navigation' which also has the columns a,b,c
>
> If the combination of (a,b,c) exists in 'navigation', then exclude it
> from above result. How can I achieve this?
From | Date | Subject | |
---|---|---|---|
Next Message | Gavin 'Beau' Baumanis | 2008-06-28 14:32:40 | distinct / group by assistance. |
Previous Message | Louis-David Mitterrand | 2008-06-27 15:11:30 | Re: dynamic events categorization |