Postgres: How to find rows in which a specific column has 'empty' values?

Question

I need to find rows which have a empty values in a column after a CSV import. The column is an INTEGER column, hence the

...
where col = ''

doesn't work for me.

osanger · Accepted Answer · 2021-12-06 21:52:20Z

1

You can check for empty values using

where col is null

If you want to select null as 0 (or any other default value) use coalesce

select coalesce(max(col), 0)

answered Dec 6, 2021 at 21:52

osanger

2,3723 gold badges31 silver badges38 bronze badges

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

1 Answer 1