Re: Show NULL values AS <NULL> not working

------=_Part_9644_15864457.1200353343356
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi Dave

Ah right OK, I didn't realise the "Query" tab was just for SQL editor, I
thought it was for the data entry grids as well.

Thanks for clearing that up.


> instead I had to do:
> >
> > "SELECT COALESCE(first_invalid, '1900-01-01') AS first_invalid FROM
> table"
> >
> > to prove the column is in fact NULL, and I do get: "1900-01-01
> 00:00:00+00"
> > for this record, but in the data entry grid, PgAdmin still displays it
> > blank.
>
> That doesn't prove it's null - it proves it's null OR 1900-01-01
> 00:00:00+00. However, the <NULL> output option is onlt for the Query
> Tool. The data entry grid always displays an empty cell for NULL, ''
> for a blank string, and \'\' for a pair or single quotes. From the
> docs:



I knew it was NULL cause the table only had 1 row in it, and I'd purposely
set it to NULL through a query ;-)

Andy

------=_Part_9644_15864457.1200353343356
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi Dave<br><br>Ah right OK, I didn&#39;t realise the &quot;Query&quot; tab
was just for SQL editor, I thought it was for the data entry grids as
well.<br><br>Thanks for clearing that up.<br><br><br><div><blockquote
class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204);
margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
&gt; instead I had to do:<br>&gt;<br>&gt; &quot;SELECT
COALESCE(first_invalid, &#39;1900-01-01&#39;) AS first_invalid FROM
table&quot;<br>&gt;<br>&gt; to prove the column is in fact NULL, and I do
get: &quot;1900-01-01 00:00:00+00&quot;
<br>&gt; for this record, but in the data entry grid, PgAdmin still
displays it<br>&gt; blank.<br><br>That doesn&#39;t prove it&#39;s null -
it proves it&#39;s null OR 1900-01-01<br>00:00:00+00. However, the
&lt;NULL&gt; output option is onlt for the Query
<br>Tool. The data entry grid always displays an empty cell for NULL,
&#39;&#39;<br>for a blank string, and \&#39;\&#39; for a pair or single
quotes. From the<br>docs:</blockquote><div><br><br>I knew it was NULL
cause the table only had 1 row in it, and I&#39;d purposely set it to NULL
through a query ;-)
<br><br></div></div>Andy<br>

------=_Part_9644_15864457.1200353343356--