| 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: | Whole Thread | Raw Message | 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
| 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 |