Re: Regarding useObjects

On Wed, 27 Sept 2023 at 06:07, Achilleas Mantzios - cloud <
a(dot)mantzios(at)cloud(dot)gatewaynet(dot)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
>
>