| From: | <ryan(at)paymentalliance(dot)net> |
|---|---|
| To: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | count and group by question |
| Date: | 2002-06-19 19:19:25 |
| Message-ID: | Pine.LNX.4.33.0206191430010.11690-100000@paymentalliance.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
I have a query which contains both a group by and a count, e.g:
SELECT
to_char(pa_shopping_cart.delivery_date, 'FMMM/FMDD/YY') AS delivery_date,
pa_products.product_name AS product_name,
pa_orders.order_state AS state,
count(*) AS count
FROM
pa_shopping_cart,
pa_products,
pa_orders
WHERE
pa_shopping_cart.order_id = pa_orders.order_id AND
pa_shopping_cart.product_id = pa_products.product_id
GROUP BY
pa_shopping_cart.delivery_date,
pa_products.product_name,
pa_orders.order_state
ORDER BY
pa_shopping_cart.delivery_date, pa_products.product_name;
This query is really handy because it gives me the count of each
product grouping by delivery within each possible order state.
Here's the question - I would like to get the count of how many tuples are
returned total. With most queries, count(*) works great for this purpose,
however I need something that will give me the total count of tuples
returned even when there is a grouping.
Any ideas?
Ryan Mahoney
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hannu Krosing | 2002-06-19 20:07:11 | Re: count and group by question |
| Previous Message | Barry Lind | 2002-06-19 19:03:36 | Re: [HACKERS] Milliseconds problem with PostgreSQL 7.2 jdbc driver |