Postgres Pro
Downloads
Home   >   mailing lists

Computing count of intersection of two queries (Relational Algebra --> SQL) - Mailing list pgsql-general

From Robert James
Subject Computing count of intersection of two queries (Relational Algebra --> SQL)
Date
Msg-id CAGYyBgiquOZpPh0_aP6tOZZNAu56_gBFq4mZWRMGkj_GRWnvTQ@mail.gmail.com
Whole thread Raw
Responses Re: Computing count of intersection of two queries (Relational Algebra --> SQL)
Re: Computing count of intersection of two queries (Relational Algebra --> SQL)
List pgsql-general
Tree view 
In relational algebra, I have relation R and relation S, and want to
find the cardinality of R, of S, and of R-intersect-S.

I know the SQL for R and S.  What's the best way to compute the
cardinality of each relation (query) and of their intersection?

pgsql-general by date:

Previous
From: giozh
Date:
Subject: Re: unable to call a function
Next
From: David Johnston
Date:
Subject: Re: Computing count of intersection of two queries (Relational Algebra --> SQL)