Re: How to properly perform this? - Mailing list 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@lurcherlink.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