----- 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? Regards Donald Fraser. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
