I have a "sparse" table in Postgres, described in Pandas: Adding zero values where no rows exist (sparse) . I'd like to add explicit rows with zero, just as described in http://stackoverflow.com/a/41370228/785494 . However, that answer shows how to do it in Python Pandas. Is there a way to do something similar directly in Postgres SQL?
Join the Stack Overflow Community
Stack Overflow is a community of 6.6 million programmers, just like you, helping each other.
Join them; it only takes a minute:
Sign up
Join them; it only takes a minute:
|
