postgresql if not null code example
Example 1: postgresql change column to not null
-- To change a column to NOT NULL:
ALTER TABLE products ALTER COLUMN product_no SET NOT NULL;
Example 2: postgresql if null then 0
select coalesce(avg(bar), 0) from foo;