Count and Intersect - Mailing list pgsql-general

From Michaël Fiey
Subject Count and Intersect
Date
Msg-id 001401c0a23f$56888200$6400a8c0@pc03
Whole thread Raw
List pgsql-general
Hi,

Is it possible to count the number of rows returned by a command which use
the intersect operator,
such as :

SELECT col1 as my_col
FROM table
WHERE <conditions 1>
INTERSECT
SELECT col1 as my_col
FROM table
WHERE <conditions 2>
INTERSECT
SELECT col1 as my_col
FROM table
WHERE <conditions 2>

Any help would be appreciated.

Regards
michael


pgsql-general by date:

Previous
From: Karel Zak
Date:
Subject: Re: DES in Postgres?
Next
From: Renaud Tthonnart
Date:
Subject: Re: Counting elements of an array