Re: How to properly perform this?

From: Nick Gorham <nick(at)lurcherlink(dot)org>
To: Igor Korot <ikorot01(at)gmail(dot)com>
Cc: Dave Cramer <davecramer(at)postgres(dot)rocks>, PostgreSQL ODBC list <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: How to properly perform this?
Date: 2026-03-09 09:03:13
Message-ID: a2de62f7-280f-496a-a49f-df4f9d6bcdd3@lurcherlink.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

On 08/03/2026 07:53, Igor Korot wrote:
> Hi, Nick,
>
> On Sat, Mar 7, 2026 at 11:41 PM Nick Gorham <nick(at)lurcherlink(dot)org> wrote:
>> If I understand the question:
>>
>> if( ind[3] == SQL_NULL_DATA )
>>
>> Assuming ind is an array of SQLLEN (ie signed).
> If I understand the spec correctly, that check shouldn't be necessary
> as the very first call to SQLGetData() should just return SQL_NO_DATA
> from the NULL column.
>
> But in the meantime I added that check.
>
> Thank you.

Can you show me where the spec says that, as I think that's wrong.
SQL_NO_DATA will be returned on call after the previous one on a column
that returns a variable length has returned SQL_SUCCESS. But anyway
that's an ODBC thing not specifically a PostgreSQL one, so maybe these
guys don't care.

--

Nick Gorham

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Igor Korot 2026-03-14 07:09:04 Does included columns part of the PK
Previous Message Igor Korot 2026-03-08 07:53:44 Re: How to properly perform this?