<!doctype html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<div>
Unsubscribe
</div>
<div class="default-style">
<br>
</div>
<blockquote type="cite">
<div>
Op 27-09-2023 12:17 schreef Dave Cramer <davecramer(at)postgres(dot)rocks>:
</div>
<div>
<br>
</div>
<div>
<br>
</div>
<div dir="ltr">
<div dir="ltr">
<br>
</div>
<br>
<div class="gmail_quote">
<div class="gmail_attr" dir="ltr">
On Wed, 27 Sept 2023 at 06:07, Achilleas Mantzios - cloud <<a href="mailto:a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com">a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com</a>> wrote:
<br>
</div>
<blockquote>
<div>
<p><br></p>
<div>
On 9/27/23 12:55, Vladimir Sitnikov wrote:
<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div>
> 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's a feature request for retrieving primitive arrays: <a target="_blank" href="https://github.com/pgjdbc/pgjdbc/issues/2939" rel="noopener">https://github.com/pgjdbc/pgjdbc/issues/2939</a>
<br>
</div>
</blockquote>
<p>back in pre-<span style="font-family: monospace;"><span style="color: #000000; background-color: #ffffff;">postgresql-42* </span></span>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.<br></p>
</div>
</blockquote>
<div>
Using that mapping is not something that we would entertain.
</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>
Dave
</div>
<blockquote>
<div>
<p><br></p>
<blockquote type="cite">
<div dir="ltr">
<br>Vladimir
<br>
<br>
</div>
</blockquote>
</div>
</blockquote>
</div>
</div>
</blockquote>
</body>
</html>