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 1vwe7l-003c90-1O for pgsql-general@arkaria.postgresql.org; Sun, 01 Mar 2026 10:34:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vwe6k-00Cjao-0d for pgsql-general@arkaria.postgresql.org; Sun, 01 Mar 2026 10:33:06 +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 1vwe6j-00Cjae-2F for pgsql-general@lists.postgresql.org; Sun, 01 Mar 2026 10:33:05 +0000 Received: from mail-wr1-x430.google.com ([2a00:1450:4864:20::430]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vwe6f-00000001vBY-43Zl for pgsql-general@lists.postgresql.org; Sun, 01 Mar 2026 10:33:04 +0000 Received: by mail-wr1-x430.google.com with SMTP id ffacd0b85a97d-439b5d78592so103286f8f.0 for ; Sun, 01 Mar 2026 02:33:02 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1772361181; x=1772965981; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=clq/pJtEjA6Q5QAjCQxZDAaVDn+XksJm5Lq8TS6rR50=; b=eq8b4Al7eQqo+P3fRXSUPzFeqDIVdcHETJU7zGCzSOwswhecD3NUwFeuFD3E2eebtG kl1QaieZna3h4MER3E2XXZQhaTGC/mpqqQ6m/zVSzSP0AzMGM6EZ4v3JkmznPZQBcfVb lqpnUmueqWgi5f6P+FcOWwZsYT8ubFFz1ItoRFfBU3jqd/I4SWNqcMC6kqb+hUdgJk2S re6dWDss7PluMmpXQUXXDxxXqQP4meJ7EJnosblWn1Zx3dD8V4e+AToyRwCCpmyWix09 mSFN12LnBqabJX1ruhQaf3R2ng5g8HM0tWX9eTbNfGY7pfPyvaxbDLzpUcVk7Hd/+459 87pw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772361181; x=1772965981; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=clq/pJtEjA6Q5QAjCQxZDAaVDn+XksJm5Lq8TS6rR50=; b=RfnWv1rZ9R6gpdfp9l8Z740Fa9NMv8V0inewbxxmv6SmXrSJIb8zgiMenCZRSkXI3S r/sL/oOYq9P5wMr7B+lI9lB6JnDmd70OaZWTKLLnhKVFZ211a6I1rgZ7D+Zvdf6wyH9I vc2VJt25JQ7xDyWGL9M+gBUq+XU3XXjsqJfq75PSyc5ImDSbX6eFEorORXUO74jrBWWW t2MVf/ULpS8mX7Yx5CurI9asNsld3TjjqkQPsrW8/oqLipG0FsJqBbGPT2q4sTzuWXaw 4xxW5AnBLlKc1+UiLGRPeA1vT0v8T+n3OPm6M0D6DvC4HR0RSxtW2GfHyqLqWs5U7y4l pzKg== X-Gm-Message-State: AOJu0YybTDJRmkc9aE9/V7fY9F+IRdHJart+Lvji9iBHRLPAXFMbVPgs 03EmcbQg9nSiSf9Pbg51BZ4xJoGI3/fK+rOLWvjIEMyXo05lMRkPI2sKTOznrnKXbTE= X-Gm-Gg: ATEYQzyyBobg2WotmKz9UfB1n29saM0yBm52h3L5yvlc2eVnI1vR+flB2G847OKWreR SqSNUuv6UJWQZ9GwmxNx0MMDBBylOl+fGrv0OvVEJMGcdyO+EjEN7EiH037r3bqjAF0q6/hbiU7 pmmgLFDgUx+Mt1rPgggs4iKhk+URpDOYGT1fagjku0BhlGuZVn59uj5azlVwkCGzD7CxT2rBe/M vKnDhL+eEg9EQq8T8gsY7A2dcwaIWBsOf5y7JDNJQUFw1Y6wxmZQuyA4THU7o64gJpfQ6vs0gCP 4oL7FlojjQW/ZpifwJ/a9UTKqIkEoj1cjxVVIUYZL3zoMdIWAqep1ctQN/zlE9Vm/teiEzyEwQi GopVN6nICRdNjZG9fqglIBtLR4y7vKJjnZHXLb7Z/YBJuqc0YS84OeuzaXgO80U+sDmPCthCUn6 YFDOEyOxEiFA+a8Z9R7bJLnxKiwjazBYZyPuISjFZ3qCDF+rTy5c1Z7iw= X-Received: by 2002:a05:600c:37c6:b0:483:96d8:9f75 with SMTP id 5b1f17b1804b1-483c9bc5b89mr142215195e9.28.1772361181508; Sun, 01 Mar 2026 02:33:01 -0800 (PST) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:270:4cd4:ad4e:e4e4:66cb:81ac]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-439b41831easm3110947f8f.12.2026.03.01.02.33.00 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sun, 01 Mar 2026 02:33:01 -0800 (PST) Message-ID: <4a5257949cef4201aa27912c6e91a7c4101a7999.camel@cybertec.at> Subject: Re: Where the info is stored From: Laurenz Albe To: Igor Korot , "David G. Johnston" Cc: "pgsql-generallists.postgresql.org" Date: Sun, 01 Mar 2026 11:33:00 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.58.3 (3.58.3-1.fc43) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sun, 2026-03-01 at 01:58 -0600, Igor Korot wrote: > It would be interesting to know what to bind ARRAY column > in ODBC code (the type in the SQLBindCol()), but that's a > different topic which is probably OT here. I'd suspect that you need to use the string representation of the array and bind it as string. Yours, Laurenz Albe