MIME-Version: 1.0
References: 
 <CA+FnnTx+VJi6o9Y8HHUxb89REdNOxBtz1AVkbvM=TGMF_xa=oA@mail.gmail.com>
 <CADK3HHJLCxp+5Q48CatYqg02hBJs0qs8DS=x=Pg5Nx64rD1F7g@mail.gmail.com>
In-Reply-To: 
 <CADK3HHJLCxp+5Q48CatYqg02hBJs0qs8DS=x=Pg5Nx64rD1F7g@mail.gmail.com>
From: Igor Korot <ikorot01@gmail.com>
Date: Sat, 7 Mar 2026 13:06:07 -0600
Message-ID: 
 <CA+FnnTwB1GJX-ZnO+oAJw+z+rmDVcfK7Huprj7oOj3V88Y2ZUA@mail.gmail.com>
Subject: Re: How to properly perform this?
To: Dave Cramer <davecramer@postgres.rocks>
Cc: PostgreSQL ODBC list <pgsql-odbc@postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BFnnTwB1GJX-ZnO%2BoAJw%2Bz%2BrmDVcfK7Huprj7oOj3V88Y2ZUA%40mail.gmail.com>
Precedence: bulk

Hi, Dave,
I think its just an empty column.

Is there a way to treat it as NULL?

P.S.: Sorry for top-posting.

On Sat, Mar 7, 2026 at 5:41=E2=80=AFAM Dave Cramer <davecramer@postgres.roc=
ks> wrote:
>
>
> Dave Cramer
> www.postgres.rocks
>
>
> On Sat, 7 Mar 2026 at 01:10, Igor Korot <ikorot01@gmail.com> wrote:
>>
>> Hi, ALL,
>> I'm trying to execute following query:
>>
>> draft=3D# SELECT c.relname AS name, ixs.tablespace, ARRAY(SELECT
>> a.attname FROM pg_attribute a WHERE a.attrelid =3D idx.indrelid AND
>> a.attnum =3D ANY(idx.indkey) AND a.attnum > 0 ORDER BY
>> array_position(idx.indkey, a.attnum) OFFSET idx.indnkeyatts) AS
>> included, c.reloptions AS storage FROM pg_index idx, pg_class c,
>> pg_namespace n, pg_class t, pg_indexes ixs WHERE ixs.indexname =3D
>> c.relname AND c.oid =3D idx.indexrelid AND t.oid =3D idx.indrelid AND
>> n.oid =3D c.relnamespace AND idx.indisprimary AND n.nspname =3D 'public'
>> AND t.relname =3D 'leagues';
>>      name     | tablespace | included | storage
>> --------------+------------+----------+---------
>>  leagues_pkey |            | {}       |
>> (1 row)
>>
>>
>> My code is as follows:
>>
>>             while( ( ret =3D SQLGetData( m_hstmt, 4, SQL_C_WCHAR,
>> index_param.get(), 255, &ind[3] ) ) !=3D SQL_NO_DATA )
>>             {
>>                 if( ret =3D=3D SQL_SUCCESS || ret =3D=3D SQL_SUCCESS_WIT=
H_INFO )
>>                 {
>>                     auto numBytes =3D ind[3];
>>                     if( ind[3] =3D=3D SQL_NO_TOTAL )
>>                         numBytes =3D 255;
>>                     else if( ind[3] > 255 )
>>                         numBytes =3D 255;
>>                     str_to_uc_cpy( options, index_param.get() );
>>                 }
>>                 else
>>                 {
>>                     GetErrorMessage( errorMsg, STMT_ERROR  );
>>                     result =3D 1;
>>                 }
>>             }
>> Unfortunately it goes into the loop because apparently the driver or
>> the server keeps seeing the last column as having data and returns
>> SQL_SUCCESS.
>>
>> What is the proper way to resolve this?
>>
>> I'm using unixODBC with PostgreSQL 16.
>>
>> My odbc.ini looks like this:
>>
>> [code]
>> [postgres]
>> Driver=3DPostgres
>> Description=3DPostgres ODBC Driver
>> UserId=3Dpostgres
>> Password=3DXXX
>> Servername=3Dlocalhost
>> Database=3Ddraft
>> Port=3D5432
>>
>> [/code]
>>
>>
>> What is the best way to proceed?
>
>
> is the last column empty or null?
>
> if not null then there is data there.
>
> Dave