MIME-Version: 1.0
References: <CA+FnnTw=18Rba2XgceRUFKQo5P7Xf9QhXT6wKF=DgzYT6K9-sw@mail.gmail.com>
In-Reply-To: <CA+FnnTw=18Rba2XgceRUFKQo5P7Xf9QhXT6wKF=DgzYT6K9-sw@mail.gmail.com>
From: Juan Rodrigo Alejandro Burgos Mella <rodrigoburgosmella@gmail.com>
Date: Tue, 9 Dec 2025 15:40:04 -0500
Message-ID: <CAHbZ42z=Xp3VYARgipRcp0cBBQP+rNNUgoAp2dPzKbgDqPapxQ@mail.gmail.com>
Subject: Re: How do I check for NULL
To: Igor Korot <ikorot01@gmail.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000003f24dc06458aeb5f"
Archived-At: <https://www.postgresql.org/message-id/CAHbZ42z%3DXp3VYARgipRcp0cBBQP%2BrNNUgoAp2dPzKbgDqPapxQ%40mail.gmail.com>
Precedence: bulk

--0000000000003f24dc06458aeb5f
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi
Did you try setting a default value to the field?

Atte
JRBM

El lun, 8 dic 2025 a las 21:40, Igor Korot (<ikorot01@gmail.com>) escribi=
=C3=B3:

> Hi, ALL,
> Consider the following scenario:
>
> CREATE TABLE test(a INT, b VARCHAR(256), c INT, d VARCHAR(256), /*
> more fields follows*/);
> CREATE UNIQUE INDEX test_x( b, c, d );
>
> Now I try to do:
>
> INSERT INTO test VALUES( 0, 'abc', 12345, (SELECT foo FROM bar),
> /*more data follow*/);
>
> My problem is:
>
> The SELECT can either return data or NULL.
> Everything is good when the data is returned, but the insert fails
> when the NULL is returned, because the field "d" is a part of UNIQUE
> INDEX.
>
> However,, I'd like to still insert the record and I'd like to do somethin=
g
> like:
>
> INSERT INTO test VALUES( 0, 'abc', 12345, IF( (SELECT foo FROM bar) =3D=
=3D
> NULL, "postgres", <select_result>), /*more data follow*/);
>
> What would be the best way to achieve this?
>
> Thank you..
>
>
>

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

<div dir=3D"ltr"><div>Hi</div><div>Did you try setting a default value to t=
he field?</div><div><br></div><div>Atte</div><div>JRBM</div></div><br><div =
class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail=
_attr">El lun, 8 dic 2025 a las 21:40, Igor Korot (&lt;<a href=3D"mailto:ik=
orot01@gmail.com">ikorot01@gmail.com</a>&gt;) escribi=C3=B3:<br></div><bloc=
kquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:=
1px solid rgb(204,204,204);padding-left:1ex">Hi, ALL,<br>
Consider the following scenario:<br>
<br>
CREATE TABLE test(a INT, b VARCHAR(256), c INT, d VARCHAR(256), /*<br>
more fields follows*/);<br>
CREATE UNIQUE INDEX test_x( b, c, d );<br>
<br>
Now I try to do:<br>
<br>
INSERT INTO test VALUES( 0, &#39;abc&#39;, 12345, (SELECT foo FROM bar),<br=
>
/*more data follow*/);<br>
<br>
My problem is:<br>
<br>
The SELECT can either return data or NULL.<br>
Everything is good when the data is returned, but the insert fails<br>
when the NULL is returned, because the field &quot;d&quot; is a part of UNI=
QUE<br>
INDEX.<br>
<br>
However,, I&#39;d like to still insert the record and I&#39;d like to do so=
mething like:<br>
<br>
INSERT INTO test VALUES( 0, &#39;abc&#39;, 12345, IF( (SELECT foo FROM bar)=
 =3D=3D<br>
NULL, &quot;postgres&quot;, &lt;select_result&gt;), /*more data follow*/);<=
br>
<br>
What would be the best way to achieve this?<br>
<br>
Thank you..<br>
<br>
<br>
</blockquote></div>

--0000000000003f24dc06458aeb5f--