Hi,
Two other ideas...
SELECT DISTINCT p.a, p.b, p.c, now(), count(item.item_pk)
FROM product p
JOIN
(select distinct a,b,c from products
except
select distinct a,b,c from navigation
)foo
USING (a,b,c)
LEFT JOIN item ON item.product_fk = product_pk
WHERE ...
GROUP BY p.a, p.b, p.c
or maybe
SELECT DISTINCT foo.*, now(), count(item.item_pk)
FROM (select distinct a,b,c from products
WHERE ...
except
select distinct a,b,c from navigation
)foo
LEFT JOIN item ON item.product_fk = product_pk
WHERE ...
GROUP BY p.a, p.b, p.c
HTH,
Marc Mamin
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
