Re: Regarding useObjects - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Regarding useObjects
Date
Msg-id CADK3HHL7JGKre6r0xVTqAQg5Em1zC5McMrgr0v6Dudzfb0DybQ@mail.gmail.com
Whole thread Raw
In response to Re: Regarding useObjects  (Achilleas Mantzios - cloud <a.mantzios@cloud.gatewaynet.com>)
Responses Re: Regarding useObjects  (Achilleas Mantzios - cloud <a.mantzios@cloud.gatewaynet.com>)
List pgsql-jdbc


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

pgsql-jdbc by date:

Previous
From: Achilleas Mantzios - cloud
Date:
Subject: Re: Regarding useObjects
Next
From: Achilleas Mantzios - cloud
Date:
Subject: Re: Regarding useObjects