Re: Show NULL values AS <NULL> not working

From: "Dave Page" <dpage(at)postgresql(dot)org>
To: "Andy Shellam" <andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Show NULL values AS <NULL> not working
Date: 2008-01-15 08:52:18
Message-ID: 937d27e10801150052u2e632fe9ge808316e81df79e7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

On 14/01/2008, Andy Shellam <andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk> wrote:
> > 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 ;-)

My point is still valid though, and as you didn't mention those
details earlier... :-)

Regards, Dave

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2008-01-15 09:38:01 Re: New sequence in 1.8.1
Previous Message Andy Shellam 2008-01-14 23:29:03 Re: Show NULL values AS <NULL> not working