On Nov 28, 2007, at 14:00 , Erik Jones wrote:
Why not just: UPDATE table SET mytime=NULL WHERE mytime='';
If mytime is a timestamp field, it won't have any values ''. I believe the OP is updating mytime to a client-supplied value which is passing '' when it probably means NULL.
Michael Glaesemann grzm seespotcode net ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
