> 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" Best regards, Mauro __________________________________________________ Do You Yahoo!? Poco spazio e tanto spam? Yahoo! Mail ti protegge dallo spam e ti da tanto spazio gratuito per i tuoi file e i messaggi http://mail.yahoo.it ---------------------------(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
