public inbox for pgsql-odbc@postgresql.org  
help / color / mirror / Atom feed
From: Nick Gorham <nick@lurcherlink.org>
To: Igor Korot <ikorot01@gmail.com>
Cc: Dave Cramer <davecramer@postgres.rocks>
Cc: PostgreSQL ODBC list <pgsql-odbc@postgresql.org>
Subject: Re: How to properly perform this?
Date: Mon, 9 Mar 2026 09:03:13 +0000
Message-ID: <a2de62f7-280f-496a-a49f-df4f9d6bcdd3@lurcherlink.org> (raw)
In-Reply-To: <CA+FnnTw5TA7wQBAayk-L_Oo783rZTrujXn_Lw9z11NhLBtmbCg@mail.gmail.com>
References: <CA+FnnTx+VJi6o9Y8HHUxb89REdNOxBtz1AVkbvM=TGMF_xa=oA@mail.gmail.com>
	<CADK3HHJLCxp+5Q48CatYqg02hBJs0qs8DS=x=Pg5Nx64rD1F7g@mail.gmail.com>
	<CA+FnnTwB1GJX-ZnO+oAJw+z+rmDVcfK7Huprj7oOj3V88Y2ZUA@mail.gmail.com>
	<CA+FnnTxF+VThVXgobZtu6-jfCc6zfqh1tC4dPtWegfov2CFW3w@mail.gmail.com>
	<8f0a1f28-d1e4-4e3d-859f-50c763978092@lurcherlink.org>
	<CA+FnnTw5TA7wQBAayk-L_Oo783rZTrujXn_Lw9z11NhLBtmbCg@mail.gmail.com>

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







reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-odbc@postgresql.org
  Cc: nick@lurcherlink.org, ikorot01@gmail.com, davecramer@postgres.rocks
  Subject: Re: How to properly perform this?
  In-Reply-To: <a2de62f7-280f-496a-a49f-df4f9d6bcdd3@lurcherlink.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox