MIME-Version: 1.0
References: <CA+FnnTwxSeLhR8zNZsoR2SAXYVf9Db+zi3+SpPqdBe==m3X-AQ@mail.gmail.com>
 <F6C9D4E2-2FC5-43B4-89F3-46C5A0A770B4@gmail.com>
In-Reply-To: <F6C9D4E2-2FC5-43B4-89F3-46C5A0A770B4@gmail.com>
From: Igor Korot <ikorot01@gmail.com>
Date: Sat, 7 Mar 2026 13:58:22 -0600
Message-ID: <CA+FnnTznxpXh8nAJhjnggpfYz0MEnEdK89FtejDNTmX87MktiA@mail.gmail.com>
Subject: Re: How to properly use TRIM()?
To: Rob Sargent <robjsargent@gmail.com>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>, 
	"David G. Johnston" <david.g.johnston@gmail.com>, 
	"pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CA%2BFnnTznxpXh8nAJhjnggpfYz0MEnEdK89FtejDNTmX87MktiA%40mail.gmail.com>
Precedence: bulk

Hi, Rob,

On Sat, Mar 7, 2026 at 1:20=E2=80=AFPM Rob Sargent <robjsargent@gmail.com> =
wrote:
>
>
>> reloptions text[]
>
>
> Then why it=E2=80=99s not showing {} as in the =E2=80=9Cincluded=E2=80=9D=
 columns?
>
> Or it=E2=80=99s an ARRAY() implementation?
>
> Thank you.
>
>>
>
> One is an empty array, the other is null. Those are not the same thing.

Following code successfully retrieves column 3 and exits, but keep
looping for column 4.

                while( ( ret =3D SQLGetData( m_hstmt, 3, SQL_C_WCHAR,
included.get(), 255, &ind[2] ) ) !=3D SQL_NO_DATA )
                {
                    if( ret =3D=3D SQL_SUCCESS || ret =3D=3D SQL_SUCCESS_WI=
TH_INFO )
                    {
                        auto numBytes =3D ind[2];
                        if( ind[2] =3D=3D SQL_NO_TOTAL )
                            numBytes =3D 255;
                        else if( ind[2] > 255 )
                            numBytes =3D 255;
                        str_to_uc_cpy( includedCol, included.get() );
                    }
                    else
                    {
                        GetErrorMessage( errorMsg, STMT_ERROR  );
                        result =3D 1;
                    }
                }
                includedCol.erase( 0, 1 );
                includedCol.pop_back();
            }
            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_WITH_I=
NFO )
                {
                    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;
                }
            }

when I tried to run it without nullif() and trim().

So I started looking for a way to return SQL_NO_DATA
on that 4th column...

Thank you.

P.S.: Sorry for kind of throwing ODBC code here. You have ODBC
related list, but this is where things get in the cross.

>
>>
>>
>> > Included is one, storage is not.
>> >
>> > Thank you.
>> >
>> >>
>> >> Given that error message, an array of text is the correct type.
>> >>
>> >> Array[]::text[]
>> >>
>> >> David J.
>> >>
>> >
>> >
>>
>>
>> --
>> Adrian Klaver
>> adrian.klaver@aklaver.com