Re: BUG: pgAdmin III View table with empty strings

Donald Fraser wrote:

>----- 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?
>
>
>
Yes, it's going on the wishlist for V2.

Regards,
Andreas