Re: Filter tables - Mailing list pgsql-general

Il Monday 12 November 2007 18:10:40 Osvaldo Rosario Kussama ha scritto:
> Try:
> SELECT DISTINCT t1.id FROM t1
>   WHERE NOT EXISTS (SELECT f1.t FROM f1
>                      WHERE NOT EXISTS (SELECT x1.t FROM t1 x1
>                                         WHERE f1.t = x1.t
>                                           AND t1.id = x1.id));
>
> Osvaldo

Nice, it seems to work. But I fear it won't with a longer f1 filter table.
Let me think about it.

--
Reg me Please