date null - Mailing list pgsql-general

From ZioBudda
Subject date null
Date
Msg-id Pine.LNX.4.03.9810231444211.3855-100000@michel.enter.it
Whole thread Raw
Responses RE: [GENERAL] date null
Re: [GENERAL] date null
List pgsql-general
Hi, how can control in a "select" if a date is not null?
I have this table:
Table    = prestito
+----------------------------------+----------------------------------+-------+
|              Field               |              Type                |
Length|
+----------------------------------+----------------------------------+-------+
| id_libro                         | varchar() not null               |
10 |
| id_utente                        | int4 not null                    |
4 |
| data_prestito                    | date                             |
4 |
| data_restituzione                | date                             |
4 |
| n_gg_prestito                    | int4 not null                    |
4 |
| notifica1                        | date                             |
4 |
| notifica2                        | date                             |
4 |
| notifica3                        | date                             |
4 |
+----------------------------------+----------------------------------+-------+

and I want to select only tuples in which notifica1 or notifica2 or
notifica3 are not null.


"Il divertimento e' giusto se la scimmia ci prende gusto"
--
Pluto Linux Press: http://ziobudda.enter.it/PLP
--
Morelli 'ZioBudda' Davide Michel - Member of Pluto Linux User Group
michel@enter.it - http://ziobudda.enter.it/
Linux Problem? Ask to linux@media.dsi.unimi.it
"/dev/ziobudda: access to /var/tmp/beer denied, use /var/adm/pineapple"


pgsql-general by date:

Previous
From: ZioBudda
Date:
Subject: select and join
Next
From: "Taral"
Date:
Subject: RE: [GENERAL] select and join