Donald Fraser wrote:
----- Original Message -----
From: "Dave Page" <[EMAIL PROTECTED]>
To: "Matej Rizman" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]
Sent: 16 July 2003 00:34
To: [EMAIL PROTECTED]
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
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
