| From: | Igor Korot <ikorot01(at)gmail(dot)com> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | Rob Sargent <robjsargent(at)gmail(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: How to properly use TRIM()? |
| Date: | 2026-03-07 20:46:09 |
| Message-ID: | CA+FnnTy5Fc5WdM=yPSL7bBDrGYHD2aQTwGbFZFuv9dHm_AAgGA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi, David,
On Sat, Mar 7, 2026 at 12:03 PM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> On Sat, Mar 7, 2026 at 12:58 PM Igor Korot <ikorot01(at)gmail(dot)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.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2026-03-07 21:29:07 | Re: How to properly use TRIM()? |
| Previous Message | David G. Johnston | 2026-03-07 20:03:19 | Re: How to properly use TRIM()? |