MIME-Version: 1.0
References: 
 <CACpofejb+KOskR1Dn=fPoi4qAiDgOXP2RKEdtKJK7OFwJ2ebbw@mail.gmail.com>
In-Reply-To: 
 <CACpofejb+KOskR1Dn=fPoi4qAiDgOXP2RKEdtKJK7OFwJ2ebbw@mail.gmail.com>
From: "Amit S." <comeonamit@gmail.com>
Date: Mon, 27 Jul 2020 11:19:47 +0530
Message-ID: 
 <CAC-OOAvv_89Yd1WwUh3dggEWTSmpRetwiRzNLcae0EGCaOvJRQ@mail.gmail.com>
Subject: Re: Not null constraint in postgre
To: Chamath Sajeewa <csgsajeewa@gmail.com>
Cc: pgsql-novice@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000902da005ab65e4cc"
Precedence: bulk

--000000000000902da005ab65e4cc
Content-Type: text/plain; charset="UTF-8"

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@gmail.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

--000000000000902da005ab65e4cc
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi Chamath,=C2=A0<div><br></div><div>Here is an article ex=
plaining the same:::</div><div><br></div><div><a href=3D"https://www.enterp=
risedb.com/postgres-tutorials/how-null-and-empty-strings-are-treated-postgr=
esql-vs-oracle">https://www.enterprisedb.com/postgres-tutorials/how-null-an=
d-empty-strings-are-treated-postgresql-vs-oracle</a><br></div><div><br></di=
v><div>Thanks, Amit</div></div><br><div class=3D"gmail_quote"><div dir=3D"l=
tr" class=3D"gmail_attr">On Mon, Jul 27, 2020 at 11:15 AM Chamath Sajeewa &=
lt;<a href=3D"mailto:csgsajeewa@gmail.com">csgsajeewa@gmail.com</a>&gt; wro=
te:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px =
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"=
auto">Hi,<div dir=3D"auto">There is a column in my table with not null cons=
traint. Default value is set to 0 for that column. In my query, column valu=
e 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.</d=
iv><div dir=3D"auto">Thank You!</div></div>
</blockquote></div><br clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr"=
 class=3D"gmail_signature"><br><span style=3D"font-family:&quot;comic sans =
ms&quot;,sans-serif">Amit Sharma</span><br></div>

--000000000000902da005ab65e4cc--