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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

no value fetch


  • From: BRINER Cedric <work(at)infomaniak(dot)ch>
  • To: pgsql-general(at)postgresql(dot)org
  • Subject: no value fetch
  • Date: Tue, 27 Jul 2004 17:05:58 +0200
  • Message-id: <41066F56.3090504@infomaniak.ch> <text/plain>

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



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group