Re: Show NULL values AS <NULL> not working

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