Stephan Szabo <[EMAIL PROTECTED]> wrote: > > > On Tue, 27 Jul 2004, BRINER Cedric wrote: > > > hi, > > > > Imagine that I have the following table where ts_sent is a timestamp(0) > > > > select * from notification; > > to_used | ts_sent | from > > ---------------------+-------------------------+--------- > > [EMAIL PROTECTED] | 2004-07-21 14:19:43+02 | amanda > > [EMAIL PROTECTED] | | postgres > > > > and so, how do I do to fetch the second line by asking : > > catch me the line where ts_sent doesn't have a value ! > > > > I've try: > > select * from notification where ts_sent = null ; > > Use ts_sent IS NULL, not ts_sent = null. > > Pretty much, <anything> = null returns null.
To expand on this... This is because NULL is nothing. Not zero, but *nothing*. Being nothing, it cannot "equal" anything. Not even itself. But a space can *contain* nothing. And it can contain "not nothing." Jim ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
