Ups, sorry, I'm idiot... changes from the default casting to text is
really helpful in clearing brain bugs...
Роман Маширов wrote:
Hi!
Excuse me, if this been discussed before, but following thing seems to
me a little bit strange:
select '2009-01-12'::date - null::date < '1 day'::interval;
Morelli 'ZioBudda' Davide Michel wrote:
> Hi, how can control in a "select" if a date is not null? [...] I
> want to select only tuples in which notifica1 or notifica2 or
> notifica3 are not null.
did you try the following?
select *
from prestito
where notifica1 is not null or
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
