> -----Original Message----- > From: Mauro Bertoli [mailto:[EMAIL PROTECTED] > Sent: 26 October 2006 09:54 > To: George Pavlov; Dave Page; pgAdmin Support > Subject: Re: [pgadmin-support] pgAdmin preBeta4 - results > > > If you want pgAdmin III to write an empty string to > > the table, you enter the > > special string '' (two single quotes) in the field. > > If you want to write a > > string containing solely two single quotes to the > > table, you need to escape > > these quotes, by typing \'\' > > I think the simplest choice is to use a Enterprise > Manager approach: CTRL + 0 (zero) is NULL, typing '' > is "strange"
It's been that way since the beginning - I don't think it's going to change now. Regards, Dave. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match