MIME-Version: 1.0
References: <CA+FnnTwxSeLhR8zNZsoR2SAXYVf9Db+zi3+SpPqdBe==m3X-AQ@mail.gmail.com>
 <F6C9D4E2-2FC5-43B4-89F3-46C5A0A770B4@gmail.com> <CA+FnnTznxpXh8nAJhjnggpfYz0MEnEdK89FtejDNTmX87MktiA@mail.gmail.com>
In-Reply-To: <CA+FnnTznxpXh8nAJhjnggpfYz0MEnEdK89FtejDNTmX87MktiA@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Sat, 7 Mar 2026 13:03:19 -0700
Message-ID: <CAKFQuwYaVKcMU0wP3SAbct8FU0H4iy=E1HxxBY-gcvmoK-GsrQ@mail.gmail.com>
Subject: Re: How to properly use TRIM()?
To: Igor Korot <ikorot01@gmail.com>
Cc: Rob Sargent <robjsargent@gmail.com>, Adrian Klaver <adrian.klaver@aklaver.com>, 
	"pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000005d6a0f064c74aba7"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwYaVKcMU0wP3SAbct8FU0H4iy%3DE1HxxBY-gcvmoK-GsrQ%40mail.gmail.com>
Precedence: bulk

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

On Sat, Mar 7, 2026 at 12:58=E2=80=AFPM Igor Korot <ikorot01@gmail.com> wro=
te:

> So I started looking for a way to return SQL_NO_DATA
> on that 4th column...
>

Doesn't "No Data" refer to the result set as a whole, not individual
columns?  I'd assume NULL is detected some other way.

David J.

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

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Sat, Mar 7, 2026 at 12:58=E2=80=AFPM Igor Korot &lt;<a =
href=3D"mailto:ikorot01@gmail.com">ikorot01@gmail.com</a>&gt; wrote:</span>=
</div></div><div class=3D"gmail_quote gmail_quote_container"><blockquote cl=
ass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid=
 rgb(204,204,204);padding-left:1ex">So I started looking for a way to retur=
n SQL_NO_DATA<br>
on that 4th column...<br></blockquote><div><br></div><div><div class=3D"gma=
il_default" style=3D"font-family:arial,helvetica,sans-serif">Doesn&#39;t &q=
uot;No Data&quot; refer to the result set as a whole, not individual column=
s?=C2=A0 I&#39;d assume NULL is detected some other way.</div><div class=3D=
"gmail_default" style=3D"font-family:arial,helvetica,sans-serif"><br></div>=
<div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-seri=
f">David J.</div></div></div></div>

--0000000000005d6a0f064c74aba7--