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.94.2) (envelope-from ) id 1qpo1e-0074Hf-VU for pgsql-jdbc@arkaria.postgresql.org; Mon, 09 Oct 2023 11:02:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qpo1c-00D73P-SI for pgsql-jdbc@arkaria.postgresql.org; Mon, 09 Oct 2023 11:02:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qo5wI-001z07-9j for pgsql-jdbc@lists.postgresql.org; Wed, 04 Oct 2023 17:45:39 +0000 Received: from csmtpq3-prd-nl1-vfz.edge.unified.services ([84.116.50.18]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qo5wE-0002DN-CK for pgsql-jdbc@postgresql.org; Wed, 04 Oct 2023 17:45:38 +0000 Received: from oxsmtp1-prd-nl1-vfz.nl1.unified.services ([100.107.81.18]) by csmtpq3-prd-nl1-vfz.edge.unified.services with esmtp (Exim 4.93) (envelope-from ) id 1qo5wC-00E5oW-J4 for pgsql-jdbc@postgresql.org; Wed, 04 Oct 2023 19:45:32 +0200 Received: from oxbe6-prd-nl1-vfz.nl1.unified.services ([100.107.81.71]) by oxsmtp1-prd-nl1-vfz.nl1.unified.services with ESMTP id o5wCqbq11uqUwo5wCqK5B6; Wed, 04 Oct 2023 19:45:32 +0200 X-Env-Mailfrom: d.kho@upcmail.nl X-Env-Rcptto: pgsql-jdbc@postgresql.org X-SourceIP: 100.107.81.71 X-CNFS-Analysis: v=2.4 cv=XLz2CytE c=1 sm=1 tr=0 ts=651da4bc cx=a_exe a=SvnJ2oNkyYtb1AparjDJCQ==:117 a=OK2lZ1ekeIwA:10 a=IkcTkHD0fZMA:10 a=Rh5JslpUAAAA:8 a=NEAV23lmAAAA:8 a=-RZh_682U-cDpAnj7nAA:9 a=g9bFxbsntpeSpdkS:21 a=_W_S_7VecoQA:10 a=lqcHg5cX4UMA:10 a=QEXdDO2ut3YA:10 a=JnFCiPYVSNOx6aJFZvsF:22 a=CRjGpuKUiiIuQkCM3vJl:22 X-Authenticated-Sender: d.kho@upcmail.nl DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=upcmail.nl; s=202002corplgsmtpnl; t=1696441532; bh=EADs8gOksiZD8OPnlnfeCBOOqu1KQSSqFbJwtOukung=; h=Date:From:To:Cc:In-Reply-To:References:Subject; b=D/G2XR9yK/sOd6Be9XD8Zgp2DpMZhBxCcjtNGeghX14HzANflrxfriNu1SBCOKTRY tHfnPfhQWQaiA7NHIxoKkV2Z9GEkwTrQNF0shoo2Iug/J1njfP2RhfpXsEpLeybYER ElG93a/VTtH+w7e8VdiTqeudpAVydJ86iqqV6jC3pAt1eDAyUBi0AlDg10+q9tg4di HA5DbY8hCJQm9f1o5eU43oCfdcOF8N1Wd8SeHmbCpBLgQatdVrJCQ3I5H1LfzYra4L wMOPkIvFoZKsz48ejskxFu3+h0X/f8/996DLQ+X41XjZeIUP5dPhsjVWazFDw4eyME JWRlFfTcYlmSg== Date: Wed, 4 Oct 2023 19:45:32 +0200 (CEST) From: DB Kho To: "d.kho@upcmail.nl" Cc: pgsql-jdbc@postgresql.org Message-ID: <210597116.420616.1696441532527@mail.ziggo.nl> In-Reply-To: References: <8d8ea6c9-85a6-d1b8-309d-b1f5bc590840@cloud.gatewaynet.com> Subject: Re: Regarding useObjects MIME-Version: 1.0 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Priority: 3 Importance: Normal X-Mailer: Open-Xchange Mailer X-Originating-IP: 178.85.246.5 X-Originating-Client: open-xchange-appsuite X-CMAE-Envelope: MS4xfPJryGoviIxwmxoNQIPqOtPcyx/K6gdpY7kuZP1Pr29cLn2tDGdUZF1XN+7tx4rryf/LtP5q/hCyiNpRLDajRsPWLua6+sIbMJoCZfrbkbxddy8gPnox bycoxmT/spXVXyI6W2GtyIQIdYqrjGNq8TSXRYTVsZL+vjXMi9AFVqyns++YR72ZGtJbH2ZnzhZ2TP57xs9YuZ8JG59b1ooPas9Vm2DfSD9MnuzGK5FrIwcl qpdZSv/7uMRK3TnymbPqxA== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk
Unsubscribe

Op 27-09-2023 12:17 schreef Dave Cramer <davecramer@postgres.rocks>:




On Wed, 27 Sept 2023 at 06:07, Achilleas Mantzios - cloud <a.mantzios@cloud.gatewaynet.com> wrote:


On 9/27/23 12:55, Vladimir Sitnikov wrote:
> So the problem with using float instead of Float is that it is impossible to have a null float and arrays can have nulls.

There's a feature request for retrieving primitive arrays: https://github.com/pgjdbc/pgjdbc/issues/2939

back in pre-postgresql-42* days we used to use -888 and -888.888 to represent int NULL and float NULL respectively, quite ...primitive but it worked. We should retain this old mapping , but once all systems are up to date we will start storing and reading NULLs in arrays as NULLs.

Using that mapping is not something that we would entertain. 

If you are going to actually store NULL in the array, how would that work with primitives ?

Dave



Vladimir