On Thu, Aug 10, 2006 at 09:30:35AM +0200, Michal Taborsky - Internet Mall wrote:
> Tom Lane napsal(a):
> >Michal Taborsky - Internet Mall <[EMAIL PROTECTED]> writes:
> >>SELECT product.product_id
> >> FROM action
> >> JOIN product ON (product.product_id=action.product_id)
> >> WHERE action.sho
Michal Taborsky - Internet Mall wrote:
> Tom Lane napsal(a):
> >Michal Taborsky - Internet Mall <[EMAIL PROTECTED]> writes:
> >>SELECT product.product_id
> >> FROM action
> >> JOIN product ON (product.product_id=action.product_id)
> >> WHERE action.shop_group_id=1
> >>AND EXISTS (SELECT 1
Tom Lane napsal(a):
Michal Taborsky - Internet Mall <[EMAIL PROTECTED]> writes:
SELECT product.product_id
FROM action
JOIN product ON (product.product_id=action.product_id)
WHERE action.shop_group_id=1
AND EXISTS (SELECT 1
FROM catalog.product_program
WHERE produc
Michal Taborsky - Internet Mall <[EMAIL PROTECTED]> writes:
> SELECT product.product_id
>FROM action
>JOIN product ON (product.product_id=action.product_id)
> WHERE action.shop_group_id=1
> AND EXISTS (SELECT 1
> FROM catalog.product_program
> WHERE product_id=prod
Hello everyone.
My (simplified) database structure is:
a) table product (15 rows)
product_id BIGINT PRIMARY KEY
title TEXT
...
b) table action (5000 rows)
action_id BIGINT PRIMARY KEY
product_id BIGINT, FK to product
shop_group_id INTEGER (there are about 5 groups, distributed about e