MIME-Version: 1.0
References: <f81c70bd-586e-79ab-d089-331696acc42a@cloud.gatewaynet.com>
 <CAB=Je-HiDQ_pSp5PTfuRUEt6WA5bNNgYWS_8Q6wUHO1qg4=RFQ@mail.gmail.com>
 <d92c73eb-3f65-f455-8a30-d4d0ed71c1e0@cloud.gatewaynet.com>
 <CAB=Je-G=X8UbhjB5HF8d9WS5eZdVUgqopvsocD5_0WpxOHcAyw@mail.gmail.com>
 <8d8ea6c9-85a6-d1b8-309d-b1f5bc590840@cloud.gatewaynet.com>
 <CADK3HH+9O5=Y4RSCxCCBaewGPWBQ3zzTjqD0DoZJuD9wCc73uQ@mail.gmail.com>
 <CAB=Je-FzZjbr2bdUFWs7O4cKCfQVfG_miKUZk16-hhh8DS_2EQ@mail.gmail.com>
 <ab1749d6-9710-12a4-b0b1-3eb38957ef18@cloud.gatewaynet.com>
In-Reply-To: <ab1749d6-9710-12a4-b0b1-3eb38957ef18@cloud.gatewaynet.com>
From: Dave Cramer <davecramer@postgres.rocks>
Date: Wed, 27 Sep 2023 06:17:37 -0400
Message-ID: 
 <CADK3HHL7JGKre6r0xVTqAQg5Em1zC5McMrgr0v6Dudzfb0DybQ@mail.gmail.com>
Subject: Re: Regarding useObjects
To: Achilleas Mantzios - cloud <a.mantzios@cloud.gatewaynet.com>
Cc: Vladimir Sitnikov <sitnikov.vladimir@gmail.com>, pgsql-jdbc@postgresql.org
Content-Type: multipart/alternative; boundary="0000000000002ddd9006065481f6"
Archived-At: 
 <https://www.postgresql.org/message-id/CADK3HHL7JGKre6r0xVTqAQg5Em1zC5McMrgr0v6Dudzfb0DybQ%40mail.gmail.com>
Precedence: bulk

--0000000000002ddd9006065481f6
Content-Type: text/plain; charset="UTF-8"

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
>
>

--0000000000002ddd9006065481f6
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote">=
<div dir=3D"ltr" class=3D"gmail_attr">On Wed, 27 Sept 2023 at 06:07, Achill=
eas Mantzios - cloud &lt;<a href=3D"mailto:a.mantzios@cloud.gatewaynet.com"=
>a.mantzios@cloud.gatewaynet.com</a>&gt; wrote:<br></div><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex">
 =20
   =20
 =20
  <div>
    <p><br>
    </p>
    <div>On 9/27/23 12:55, Vladimir Sitnikov
      wrote:<br>
    </div>
    <blockquote type=3D"cite">
     =20
      <div dir=3D"ltr">
        <div>&gt; So the problem with using float instead of Float is
          that it is impossible to have a null float and arrays can have
          nulls.<br>
        </div>
        <div><br>
        </div>
        There&#39;s a feature request for retrieving primitive arrays: <a h=
ref=3D"https://github.com/pgjdbc/pgjdbc/issues/2939" target=3D"_blank">http=
s://github.com/pgjdbc/pgjdbc/issues/2939</a><br>
      </div>
    </blockquote>
    <p>back in pre-<span style=3D"font-family:monospace"><span style=3D"col=
or:rgb(0,0,0);background-color:rgb(255,255,255)">postgresql-42*
        </span></span>days<span style=3D"font-family:monospace"></span> 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.<br></p></div></bl=
ockquote><div>Using that mapping is not something that we would entertain.=
=C2=A0</div><div><br></div><div>If you are going to actually store NULL in =
the array, how would that work with primitives ?</div><div><br></div><div>D=
ave</div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8e=
x;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><p>
    </p>
    <blockquote type=3D"cite">
      <div dir=3D"ltr"><br>
        Vladimir<br>
        <br>
      </div>
    </blockquote>
  </div>

</blockquote></div></div>

--0000000000002ddd9006065481f6--