Count and Intersect

From: Michaël Fiey <m(dot)fiey(at)futuresoundtech(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Count and Intersect
Date: 2001-03-01 11:03:53
Message-ID: 001401c0a23f$56888200$6400a8c0@pc03
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Renaud Tthonnart 2001-03-01 12:18:08 Re: Counting elements of an array
Previous Message Karel Zak 2001-03-01 10:27:15 Re: DES in Postgres?