Horton
Menu

Re: How to properly use TRIM()?

Igor Korot <ikorot01@gmail.com>

View thread
From: Igor Korot <ikorot01@gmail.com>
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>
Date: 2026-03-07T20:46:09Z
Lists: pgsql-general 
Hi, David,

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

> On Sat, Mar 7, 2026 at 12:58 PM Igor Korot <ikorot01@gmail.com> wrote:
>
>> 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’s 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.
>