no value fetch - Mailing list pgsql-general

From BRINER Cedric
Subject no value fetch
Date
Msg-id 41066F56.3090504@infomaniak.ch
Whole thread Raw
Responses Re: no value fetch  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-general
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 ;
without success...

Anyone has an idea how to do this ?

Thanks in advance !

Cedric BRINER

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: PostgreSQL running in FreeBSD jail corrupts PostgreSQL running on the host system
Next
From: Arguile
Date:
Subject: Re: isNumeric function?