use IS NOT NULL:
SELECT * from prestito WHERE notifica1 IS NOT NULL OR notifica2 IS NOT NULL
OR notifica3 IS NOT NULL;
I seem to remember that the equality/inequality operators don't work on NULL
right now...
Taral
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECT
> i have make this try:
> esame=> select utente.cognome, prestito.id_utente, libro.tipo,
> count(*) from prestito, libro where libro.id_libro =
> prestito.id_libro and utente.id_utente = prestito.id_utente group
> by id_utente, tipo\g
>
> but the output is :
> ERROR: parser: illegal use of aggreg
Hi, how can control in a "select" if a date is not null?
I have this table:
Table= prestito
+--+--+---+
| Field | Type|
Length|
+--+--
Hi, I have this 3 table:
esame=> \d prestito
Table= prestito
+--+--+---+
| Field | Type| Length|
+--+--+-
From: Strategic Software SA
Date: 10/23/98 10:01:40 AM
Ref: UESA95770
Hello all
Can PostgreSQL do replication?
Thank You
Ulrich Enslin
[EMAIL PROTECTED]
