Re: no value fetch

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
> ---------------------+-------------------------+---------
>  amanda@obs.unige.ch |  2004-07-21 14:19:43+02 | amanda
>  amanda@obs.unige.ch |                         | 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.