Request a Demo
Home   >   mailing lists

Re: How to properly use TRIM()? - Mailing list pgsql-general

From Igor Korot
Subject Re: How to properly use TRIM()?
Date
Msg-id CA+FnnTy5Fc5WdM=yPSL7bBDrGYHD2aQTwGbFZFuv9dHm_AAgGA@mail.gmail.com
Whole thread Raw
In response to Re: How to properly use TRIM()?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: How to properly use TRIM()?
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: How to properly use TRIM()?
Next
From: Adrian Klaver
Date:
Subject: Re: How to properly use TRIM()?