Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group