6 ms·
Something along the lines of COALESCE(my_column, -1) might work for you in this case. See [1] for documentation on it in Postgres (it is in ANSI SQL though)
by AdrianoKF 7y ago
Something along the lines of
COALESCE(my_column, -1)
might work for you in this case. See [1] for documentation on it in Postgres (it is in ANSI SQL though).
[1]: https://www.postgresql.org/docs/current/functions-conditional.html#FUNCTIONS-COALESCE-NVL-IFNULL https://www.postgresql.org/docs/current/functions-conditiona...