Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: NULLIF problem
- From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
- To: Erik Jones <erik(at)myemma(dot)com>
- Cc: "Gera Mel Handumon" <geramel(dot)h(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org
- Subject: Re: NULLIF problem
- Date: Thu, 29 Nov 2007 07:46:03 -0500
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
- References:
- NULLIF problem
- From: Gera Mel Handumon
- Re: NULLIF problem
- From: Michael Glaesemann
- Re: NULLIF problem
- From: Erik Jones
- NULLIF problem
- Prev by Date: Re: NULLIF problem
- Next by Date: statement-level trigger sample out there?
- Previous by thread: Re: NULLIF problem
- Next by thread: Re: NULLIF problem
- Indexes: