counting rows returned in postgresql

Question

I need to count the number of rows returned from database.By using following code

rv = plpy.execute("SELECT * FROM AA where name = 'active '") 
rv[0]["id"] 

works when some values are returned but I need to check if no values are returned: Can someone help please.

Answer 1

Why don't you just check the size of the rv array?

Answer 2

Why dont you use -

SELECT Count(*) as rowCount FROM AA where name = 'active'

This will return you the number of rows from the query. If there are no rows, then it will return 0.