On Fri, Oct 17, 2008 at 1:30 PM, Kynn Jones <kynnjo@xxxxxxxxx> wrote: > Suppose I have two table X and Y and I want to compute the ratio of the > number of rows in X and the number of rows in Y. What would be the SQL I > could type into a psql session to get this number? > This is an example of the recurring problem of performing arithmetic using > the result of various calls to count(*) (or other mathematic functions). do you need exact or approximate answers for the number of rows? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
