Re: Not null constraint in postgre

Hi,
column data type is int4.
Thanks!

On Mon, 27 Jul 2020, 11:19 Amit S., <comeonamit(at)gmail(dot)com> wrote:

> 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
>