Re: exclude part of result

Hi,

Two other ideas...

SELECT DISTINCT p.a, p.b, p.c, now(), count(item.item_pk)=20
FROM product p=20
     JOIN
     (select distinct a,b,c from  products
      except
      select distinct a,b,c from  navigation
     )foo=20=20
     USING (a,b,c)
     LEFT JOIN item ON item.product_fk =3D product_pk
WHERE ...
GROUP BY p.a, p.b, p.c


or maybe=20

SELECT DISTINCT foo.*, now(), count(item.item_pk)=20
FROM (select distinct a,b,c from  products
      WHERE ...
      except
      select distinct a,b,c from  navigation
     )foo=20=20
     LEFT JOIN item ON item.product_fk =3D product_pk
WHERE ...
GROUP BY p.a, p.b, p.c

HTH,

Marc Mamin

--=20
Sent via pgsql-sql mailing list (pgsql-sql@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql