no value fetch

From: BRINER Cedric <work(at)infomaniak(dot)ch>
To: pgsql-general(at)postgresql(dot)org
Subject: no value fetch
Date: 2004-07-27 15:05:58
Message-ID: 41066F56.3090504@infomaniak.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)obs(dot)unige(dot)ch | 2004-07-21 14:19:43+02 | amanda
amanda(at)obs(dot)unige(dot)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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2004-07-27 15:14:44 Re: Trigger on Postgres for tables syncronization
Previous Message Tom Lane 2004-07-27 14:54:57 Re: open of /usr/lib/pgsql/data/pg_clog/0F3E failed