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
