MIME-Version: 1.0
References: 
 <CA+FnnTx+VJi6o9Y8HHUxb89REdNOxBtz1AVkbvM=TGMF_xa=oA@mail.gmail.com>
In-Reply-To: 
 <CA+FnnTx+VJi6o9Y8HHUxb89REdNOxBtz1AVkbvM=TGMF_xa=oA@mail.gmail.com>
From: Dave Cramer <davecramer@postgres.rocks>
Date: Sat, 7 Mar 2026 06:40:43 -0500
Message-ID: 
 <CADK3HHJLCxp+5Q48CatYqg02hBJs0qs8DS=x=Pg5Nx64rD1F7g@mail.gmail.com>
Subject: Re: How to properly perform this?
To: Igor Korot <ikorot01@gmail.com>
Cc: PostgreSQL ODBC list <pgsql-odbc@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000b88ccb064c6da4da"
Archived-At: 
 <https://www.postgresql.org/message-id/CADK3HHJLCxp%2B5Q48CatYqg02hBJs0qs8DS%3Dx%3DPg5Nx64rD1F7g%40mail.gmail.com>
Precedence: bulk

--000000000000b88ccb064c6da4da
Content-Type: text/plain; charset="UTF-8"

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=# SELECT c.relname AS name, ixs.tablespace, ARRAY(SELECT
> a.attname FROM pg_attribute a WHERE a.attrelid = idx.indrelid AND
> a.attnum = 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 =
> c.relname AND c.oid = idx.indexrelid AND t.oid = idx.indrelid AND
> n.oid = c.relnamespace AND idx.indisprimary AND n.nspname = 'public'
> AND t.relname = 'leagues';
>      name     | tablespace | included | storage
> --------------+------------+----------+---------
>  leagues_pkey |            | {}       |
> (1 row)
>
>
> My code is as follows:
>
>             while( ( ret = SQLGetData( m_hstmt, 4, SQL_C_WCHAR,
> index_param.get(), 255, &ind[3] ) ) != SQL_NO_DATA )
>             {
>                 if( ret == SQL_SUCCESS || ret == SQL_SUCCESS_WITH_INFO )
>                 {
>                     auto numBytes = ind[3];
>                     if( ind[3] == SQL_NO_TOTAL )
>                         numBytes = 255;
>                     else if( ind[3] > 255 )
>                         numBytes = 255;
>                     str_to_uc_cpy( options, index_param.get() );
>                 }
>                 else
>                 {
>                     GetErrorMessage( errorMsg, STMT_ERROR  );
>                     result = 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=Postgres
> Description=Postgres ODBC Driver
> UserId=postgres
> Password=XXX
> Servername=localhost
> Database=draft
> Port=5432
>
> [/code]
>
>
> What is the best way to proceed?
>

is the last column empty or null?

if not null then there is data there.

Dave

--000000000000b88ccb064c6da4da
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div><br clear=3D"all"></div><div><div di=
r=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Dave Cramer<div>www.po=
stgres.rocks</div></div></div></div><br></div><br><div class=3D"gmail_quote=
 gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Sat, 7 Mar=
 2026 at 01:10, Igor Korot &lt;<a href=3D"mailto:ikorot01@gmail.com">ikorot=
01@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" styl=
e=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);paddin=
g-left:1ex">Hi, ALL,<br>
I&#39;m trying to execute following query:<br>
<br>
draft=3D# SELECT c.relname AS name, ixs.tablespace, ARRAY(SELECT<br>
a.attname FROM pg_attribute a WHERE a.attrelid =3D idx.indrelid AND<br>
a.attnum =3D ANY(idx.indkey) AND a.attnum &gt; 0 ORDER BY<br>
array_position(idx.indkey, a.attnum) OFFSET idx.indnkeyatts) AS<br>
included, c.reloptions AS storage FROM pg_index idx, pg_class c,<br>
pg_namespace n, pg_class t, pg_indexes ixs WHERE ixs.indexname =3D<br>
c.relname AND c.oid =3D idx.indexrelid AND t.oid =3D idx.indrelid AND<br>
n.oid =3D c.relnamespace AND idx.indisprimary AND n.nspname =3D &#39;public=
&#39;<br>
AND t.relname =3D &#39;leagues&#39;;<br>
=C2=A0 =C2=A0 =C2=A0name=C2=A0 =C2=A0 =C2=A0| tablespace | included | stora=
ge<br>
--------------+------------+----------+---------<br>
=C2=A0leagues_pkey |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | {}=C2=A0 =
=C2=A0 =C2=A0 =C2=A0|<br>
(1 row)<br>
<br>
<br>
My code is as follows:<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 while( ( ret =3D SQLGetData( m_hs=
tmt, 4, SQL_C_WCHAR,<br>
index_param.get(), 255, &amp;ind[3] ) ) !=3D SQL_NO_DATA )<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 {<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 if( ret =3D=3D SQL_=
SUCCESS || ret =3D=3D SQL_SUCCESS_WITH_INFO )<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 {<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 auto =
numBytes =3D ind[3];<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 if( i=
nd[3] =3D=3D SQL_NO_TOTAL )<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 numBytes =3D 255;<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 else =
if( ind[3] &gt; 255 )<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 numBytes =3D 255;<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 str_t=
o_uc_cpy( options, index_param.get() );<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 }<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 else<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 {<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 GetEr=
rorMessage( errorMsg, STMT_ERROR=C2=A0 );<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 resul=
t =3D 1;<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 }<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 }<br>
Unfortunately it goes into the loop because apparently the driver or<br>
the server keeps seeing the last column as having data and returns<br>
SQL_SUCCESS.<br>
<br>
What is the proper way to resolve this?<br>
<br>
I&#39;m using unixODBC with PostgreSQL 16.<br>
<br>
My odbc.ini looks like this:<br>
<br>
[code]<br>
[postgres]<br>
Driver=3DPostgres<br>
Description=3DPostgres ODBC Driver<br>
UserId=3Dpostgres<br>
Password=3DXXX<br>
Servername=3Dlocalhost<br>
Database=3Ddraft<br>
Port=3D5432<br>
<br>
[/code]<br>
<br>
<br>
What is the best way to proceed?<br></blockquote><div><br></div><div>is the=
 last column empty or null?</div><div><br></div><div>if not null then there=
 is data there.</div><div><br></div><div>Dave</div></div></div>

--000000000000b88ccb064c6da4da--