PostgreSQL Stored Procedure

Question

I have two separate PostgreSQL count queries that I would like to output as one combined report. I have done a little bit of research into this and found that it could be done through a stored procedure, but I am not sure how I should go about doing this (I'm fairly new to Postgres programming).

Both of the queries are returning counts.

Any insight into this would be much appreciated!

Do you want each count returned as a column, or as a row?

cdhowie
– cdhowie

2011-09-07 20:14:40 +00:00
Commented Sep 7, 2011 at 20:14 — cdhowie
– cdhowie, Commented Sep 7, 2011 at 20:14

Daniel Lyons · Accepted Answer · 2011-09-07 20:16:32Z

5

You don't even need a stored procedure for this. You can just make one big query:

SELECT a.a_count, b.b_count FROM
  (SELECT COUNT(*) a_count FROM table_a) AS a,
  (SELECT COUNT(*) b_count FROM table_b) AS b;

answered Sep 7, 2011 at 20:16

Daniel Lyons

22.9k3 gold badges54 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

orkutWasNotSoBad · Accepted Answer · 2011-09-07 20:18:33Z

0

I don't believe PostgreSQL has stored procedures, only functions. However, you could do what you're talking about with a FUNCTION.

CREATE FUNCTION getQtyOrders(customerID int) RETURNS int AS $$
DECLARE
qty int;
BEGIN
SELECT COUNT(*) INTO qty
FROM Orders
WHERE accnum = customerID;
RETURN qty;
END;

answered Sep 7, 2011 at 20:18

orkutWasNotSoBad

6387 silver badges12 bronze badges

Collectives™ on Stack Overflow

PostgreSQL Stored Procedure

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related