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>
 <CAKFQuwYaVKcMU0wP3SAbct8FU0H4iy=E1HxxBY-gcvmoK-GsrQ@mail.gmail.com>
In-Reply-To: <CAKFQuwYaVKcMU0wP3SAbct8FU0H4iy=E1HxxBY-gcvmoK-GsrQ@mail.gmail.com>
From: Igor Korot <ikorot01@gmail.com>
Date: Sat, 7 Mar 2026 12:46:09 -0800
Message-ID: <CA+FnnTy5Fc5WdM=yPSL7bBDrGYHD2aQTwGbFZFuv9dHm_AAgGA@mail.gmail.com>
Subject: Re: How to properly use TRIM()?
To: "David G. Johnston" <david.g.johnston@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="000000000000158e9d064c75437b"
Archived-At: <https://www.postgresql.org/message-id/CA%2BFnnTy5Fc5WdM%3DyPSL7bBDrGYHD2aQTwGbFZFuv9dHm_AAgGA%40mail.gmail.com>
Precedence: bulk

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

Hi, David,

On Sat, Mar 7, 2026 at 12:03=E2=80=AFPM David G. Johnston <
david.g.johnston@gmail.com> wrote:

> On Sat, Mar 7, 2026 at 12:58=E2=80=AFPM Igor Korot <ikorot01@gmail.com> w=
rote:
>
>> 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.
>

No, I think it=E2=80=99s column based.
The call to SQLGetData() returns data in one column.

And as stated it successfully retrieves empty array for column 3 and moves
on.

Thank you.


> David J.
>

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

<div dir=3D"auto">Hi, David,</div><div><br><div class=3D"gmail_quote gmail_=
quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Sat, Mar 7, 2026 =
at 12:03=E2=80=AFPM David G. Johnston &lt;<a href=3D"mailto:david.g.johnsto=
n@gmail.com">david.g.johnston@gmail.com</a>&gt; wrote:<br></div><blockquote=
 class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc soli=
d;padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_d=
efault" style=3D"font-family:arial,helvetica,sans-serif"><span style=3D"fon=
t-family:Arial,Helvetica,sans-serif">On Sat, Mar 7, 2026 at 12:58=E2=80=AFP=
M Igor Korot &lt;<a href=3D"mailto:ikorot01@gmail.com" target=3D"_blank">ik=
orot01@gmail.com</a>&gt; wrote:</span></div></div><div class=3D"gmail_quote=
"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;borde=
r-left:1px solid rgb(204,204,204);padding-left:1ex">So I started looking fo=
r a way to return 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></div><=
/div></blockquote><div dir=3D"auto"><br></div><div dir=3D"auto">No, I think=
 it=E2=80=99s column based.</div><div dir=3D"auto">The call to SQLGetData()=
 returns data in one column.</div><div dir=3D"auto"><br></div><div dir=3D"a=
uto">And as stated it successfully retrieves empty array for column 3 and m=
oves on.</div><div dir=3D"auto"><br></div><div dir=3D"auto">Thank you.</div=
><div dir=3D"auto"><br></div><blockquote class=3D"gmail_quote" style=3D"mar=
gin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr=
"><div class=3D"gmail_quote"><div><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif" dir=3D"auto"></div><div class=3D"gmail=
_default" style=3D"font-family:arial,helvetica,sans-serif"><br></div><div c=
lass=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif">Dav=
id J.</div></div></div></div>
</blockquote></div></div>

--000000000000158e9d064c75437b--