Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vza7J-0018Py-2L for pgsql-odbc@arkaria.postgresql.org; Mon, 09 Mar 2026 12:53:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vza7H-00G3Px-05 for pgsql-odbc@arkaria.postgresql.org; Mon, 09 Mar 2026 12:53:47 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vzWWM-00FBdV-0q for pgsql-odbc@lists.postgresql.org; Mon, 09 Mar 2026 09:03:26 +0000 Received: from mout.kundenserver.de ([217.72.192.75]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vzWWK-00000001G6U-2b1K for pgsql-odbc@postgresql.org; Mon, 09 Mar 2026 09:03:25 +0000 Received: from client.hidden.invalid by mrelayeu.kundenserver.de (mreue109 [212.227.15.179]) with ESMTPSA (Nemesis) id 1MRmsG-1w5faA1MwE-00Ohqm; Mon, 09 Mar 2026 10:03:16 +0100 Message-ID: Date: Mon, 9 Mar 2026 09:03:13 +0000 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: How to properly perform this? To: Igor Korot Cc: Dave Cramer , PostgreSQL ODBC list References: <8f0a1f28-d1e4-4e3d-859f-50c763978092@lurcherlink.org> Content-Language: en-US From: Nick Gorham In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Provags-ID: V03:K1:yO/3zF2bagxISoPT3IaYElp9U4GXtpx+EZo5ffTmhi210s0hFlx GsupP0DQ5dHgBDyrwpqgNcAoXOhiMY3HjVtVMbTpCjTGuH79FMc4pBsl4rHMhtnrorB8nPy Z3jPvzJylDukadSWj9aJ4qQP2tsjoQBzzwTrLDxgK90lNwnP+MyvVnd6WnOqPS7bRLXKEpv JTdD0CNxrLGrzEWfjM/CA== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:S+D4GAIAMuM=;4svVa1W8t1rUXcwLns/ST2g9TxU bXgCjC3Dnewg7KmJUhq+ZeohpEEYIdFZqzUIHXjN/YenZ49+nC7y9Wi3ekWouX2wGSprOYfyH yKLDJy6WELQC1GfZTMLVZ+Okknj38xxfwUN4Bgn+/33XNUdDfdSuS3dzzOv/GDEVIMLtMiRoE qvt39MxpXSEAMXOSPIui9WXRITgKzOFNSDmpxTGMYXOculnT05kJbbtd/sqJhbUnWRBcB0XEQ VI7LAQ+/T4woKiFuQ9hHwXEuALX5iylLuYpl3ccBa007yjsIYcAupzoXTI2pv6m/Fqj0bjePW cATzSscJsK/yTrOmxjHSNJDYzR+a89sAH2aL9M7nc3G4Wx3czEooK28tq4umGCchiFPiOYEnm YKhLhIQ5/ixgkpuhJbR0Tqw3BID68kPd3O7fAu/YCFxWLn9H9jIwS3YwlcXrlyBfQaL7S170h 3kOHhEuFZolo5PYbma9WFXXFluwGdHBD1JgPKfQqMterZccsuDN6vv86Ioj/8ZYtvO29LUFsO JKsQaWLCCsE6TLmnXws1tNhiOW9Fs/vMQAUj0mGjYVFgG3DE2BeMenFbMR+DFy3gtIxZRTjvN ljlMeePaaqejofKrhDOeULJMC7jyDI0z0vxa9iHOXPf06Y1TccS320wHEs5Hpjz0oDbzZ46i9 MeL/hIJWcEzXMwv6YeCN1piUJRw+LycRyrPXi8Ejj/k///+f7rf85YKRiiaa0F+VnmpGDgKpG ++u3FRX1BAF90bFJa9cL2F8QPnUvIz0+lICeGg55GsFnMYWRiaapiwuVtKkgO0nUyLUjABiQH fLjt4L3GdmGWHKzeKK/r504g0CD1ON3nwDd7WrbmCU4UCrJ2RTW3sI+FSjRwckWVizvAxE/zo LndcFcccZTYaP8CHB7N9q2Z6+Z8SH8leUM0xkv+YT4q5zVg2uvBjaFZzsOCDjwqKAcDH87ZYp M3A5ud5XKFut4IhTpbOQwtwnVEx1K4riZ0Qvag/qQPIn51cY9WEQvgQoUiEs9+jwgTgZPQdnv 1QVc5K/753rfnc/DpL1Eb3X3pzV7xKe1LkKC1/I4x4eYdYrpTqDgRFDY4Rp5iJ9rCfpNURPl+ VyXJKzp0krBkkAqLd/6yFAyXbd6xWhwQJtq44qxp8N6xy+R8kri2881MwQWXavOXanIKcBSeY UmuqNMEDwbdc+D2XXxsn11Vtw37q9BzLCfuazLMsTi1jEj3Z9J/rUfckiNJtBbtpTGI7KWcu9 Y8ZaaWkMds2nbYomumDtGTCKmZKhCGAilhJAu0GkVOQ6P/z1a6UOSSOYJomt24cKjfhXZZIxD 5I24JF6lZGSVLVeakqGif/ERIFCXGSzThQBuPFop8kf9OgzkvBB+ruh+Porg0xtFU1TSjrcC8 ck4wBmPuz8JLlfSIFbscQbASW2f6liLspPK3lY5nTdR44g8sabXDsmFRXoSZVLFID52FApsm3 XDLDN3UmYB3Tq9M3CcB1fFACICDVpfsn2OOTSOfNKg+A+peigpDJMqM+aYfJ5+O/bG+9mDLvL qv9Fk+1mOhwIcZtGraJypsyMbbI8ED5UqK6hZzhN2G2jGsxWFbkm1fX+pV0T+56mTheMo/1nk 5fDZqyDXIboUn5z9mjS6BW1UKp+Ici7+snnQO8z52BIfQPeG9CHx1NlEgen3pHvm8o5ZoHjFl F86v4nU2VPmvOhd8Dfpoc1lgJciDys6Io0E3u2IYnZ1BqkpyH3/lAkVswFYjum+AAtRzpu8yC ru8IE6J2hqemI6TktMrm+DMUjjwGpxZDbKLfTipTL8CbEEkya8jGF45/mJIGRlbta5mj0jhdI Lyf4 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 08/03/2026 07:53, Igor Korot wrote: > Hi, Nick, > > On Sat, Mar 7, 2026 at 11:41 PM Nick Gorham 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