Re: [PERFORM] Multiple Uniques

2004-09-02 Thread Greg Stark
Markus Schaber <[EMAIL PROTECTED]> writes: > logigis=# explain select count(id) from (select ref_in_id as id from streets union > select nref_in_id as id from streets) as blubb; >QUERY PLAN > > ---

Re: [PERFORM] Multiple Uniques

2004-09-02 Thread Tom Lane
Markus Schaber <[EMAIL PROTECTED]> writes: > Today, we stumbled about the following query plan on PostGreSQL 7.4.1: > logigis=# explain select count(id) from (select distinct id from (select distinct > ref_in_id as id from streets union select distinct nref_in_id as id from streets) as > blubb)

[PERFORM] Multiple Uniques

2004-09-02 Thread Markus Schaber
Hello, Today, we stumbled about the following query plan on PostGreSQL 7.4.1: logigis=# explain select count(id) from (select distinct id from (select distinct ref_in_id as id from streets union select distinct nref_in_id as id from streets) as blubb) as blabb;