Re: BUG: pgAdmin III View table with empty strings

----- Original Message -----
From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Matej Rizman" <matej(dot)rizman(at)guest(dot)arnes(dot)si>;
<pgadmin-support(at)postgresql(dot)org>
Sent: Wednesday, July 16, 2003 3:27 PM
Subject: Re: [pgadmin-support] BUG: pgAdmin III View table with empty strings

>> -----Original Message-----
>> From: Matej Rizman [mailto:matej(dot)rizman(at)guest(dot)arnes(dot)si]
>> Sent: 16 July 2003 00:34
>> To: pgadmin-support(at)postgresql(dot)org
>> Subject: [pgadmin-support] BUG: pgAdmin III View table with
>> empty strings
>>
>>
>> Version: 0.8.0 (Jul 14 2003), Win32 version
>>
>> Steps:
>> 1) create table with one varchar column
>> CREATE TABLE public.test
>> (
>> a varchar(50) NOT NULL
>> ) WITHOUT OIDS;
>>
>> 2) fill it with some empty strings
>> INSERT INTO test(a) VALUES('')
>>
>> 3) run pgAdmin III, select table and choose view data from popup menu
>>
>> 4) pgAdmin III shows two apostrophes ('') instead of empty strings.

>Hi,
>
>That is by design and is described in the new docs/en_US/editgrid.html
>file. The two single quotes represents empty string, whereas an empty
>box represents NULL.

Might I add my 2 cents worth:
If you have a string type column with a value of lets say two or more spaces
e.g. ' '::text, you cannot see the difference between that and a column that
returns NULL.
May be in this day and age of GUIs, a different colour might help?

Regards
Donald Fraser.