Replacing empty integer cells with 0 in postgreSQL

Question

I have a view

matches_view

returning the following:

 id |      name      | wins | losses | matches
----+----------------+------+--------+---------
  2 | Peter          |    1 |      2 |       3
  1 | Kevin          |    3 |      1 |       4
  3 | John           |      |      1 |

How can I replace the empty columns in the last row with 0s in postgreSQL?

What is the view definition? I'm guessing the "empty" fields are null, so it might be as easy as using COALESCE(field, 0), but it's impossible to tell withough knowing how the view is generated. — jmelesky
– jmelesky, Commented Nov 13, 2016 at 17:51

Erwin Brandstetter · Accepted Answer · 2023-05-11 12:12:45Z

4

You can use COALESCE(<expression>, 0) for numeric columns in any case.

edited May 11, 2023 at 12:12

answered Nov 13, 2016 at 17:54

Erwin Brandstetter

669k160 gold badges1.2k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

Replacing empty integer cells with 0 in postgreSQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related