How to count empty rows in postgresql?

Question

In my postgresql query given below and I want to count(completed::float)

select round(Count(completed::float)) as completed,
       assignee 
from NTE_23Apr19_HCMS_DOW_Defects_List_V1 
group by assignee

This is my postgresql table

enter image description here

If I used without float in query it will works but I want to execute with float.Is It possible

select round(Count(completed)) as completed,
       assignee 
from NTE_23Apr19_HCMS_DOW_Defects_List_V1 
group by assignee

count(completed) and count(completed::float) or even count(completed)::float will all return the same value. What exactly are you trying to do? Maybe you just want count(*)? — user330315
– user330315, Commented Apr 24, 2019 at 5:49
If I used count(completed)::float instead of count(completed::float).It works — arun kumar
– arun kumar, Commented Apr 24, 2019 at 6:02
Then I have no idea what you are trying to do. count returns an integer, casting that integer to float won't change its value. And counting float values won't return a different count that counting integer values. What exactly does "it works" mean? Do you get an error if it does "not work"? Is your screen shot the result you get or the result you expect? — user330315
– user330315, Commented Apr 24, 2019 at 6:07
Please edit your question and add a Minimal, Complete, and Verifiable example which should consist of a create table statement, some insert statements and the expected output as formatted text no screen shots please. edit your question do not post code in comments — user330315
– user330315, Commented Apr 24, 2019 at 6:07

Georgi Raychev · Accepted Answer · 2019-04-24 06:39:51Z

2

There's no such thing as an empty row in PostgreSQL. Your value is either '' (empty string), or a NULL value. You can count those the following ways:

sum(case when completed = '' then 1 else 0 end)

sum(case when completed is null then 1 else 0 end)

better yet:

sum(case when coalesce(completed,'') = '' then 1 else 0 end) - which will cover both situations.

answered Apr 24, 2019 at 6:39

Georgi Raychev

1,3441 gold badge13 silver badges26 bronze badges

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

2 Comments

arun kumar Over a year ago

I want count(decimal),sum(int),avg(float) in above table.If anyone knows please guide me.

Georgi Raychev Over a year ago

You're going to have to add your desired results to your question.

Collectives™ on Stack Overflow

How to count empty rows in postgresql?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related