Hi Chamath,
Here is an article explaining the same:::
https://www.enterprisedb.com/postgres-tutorials/how-null-and-empty-strings-are-treated-postgresql-vs-oracle
Thanks, Amit
On Mon, Jul 27, 2020 at 11:15 AM Chamath Sajeewa <csgsajeewa(at)gmail(dot)com>
wrote:
> Hi,
> There is a column in my table with not null constraint. Default value is
> set to 0 for that column. In my query, column value is set to null. When i
> try to execute that query in pgsql, it is getting failed due to constraint
> violation. Any idea? This is working in oracle.
> Thank You!
>
--
Amit Sharma