From: | ZioBudda <michel(at)michel(dot)enter(dot)it> |
---|---|
To: | pgsql-general(at)postgreSQL(dot)org |
Subject: | date null |
Date: | 1998-10-23 12:47:04 |
Message-ID: | Pine.LNX.4.03.9810231444211.3855-100000@michel.enter.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)enter(dot)it - http://ziobudda.enter.it/
Linux Problem? Ask to linux(at)media(dot)dsi(dot)unimi(dot)it
"/dev/ziobudda: access to /var/tmp/beer denied, use /var/adm/pineapple"
From | Date | Subject | |
---|---|---|---|
Next Message | Taral | 1998-10-23 17:56:16 | RE: [GENERAL] select and join |
Previous Message | ZioBudda | 1998-10-23 12:22:14 | select and join |