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;
ERROR: operator does not exist: integer < interval
LINE 1: select '2009-11-12'::date - null::date < '1 day'::interval;
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
[mailto:[EMAIL PROTECTED]]On Behalf Of ZioBudda
> Sent: Friday, October 23, 1998 7:47 AM
> To: [EMAIL PROTECTED]
> Subject: [GENERAL] date null
>
>
> Hi, how can control in a "select" if a date is not null?
Hi, how can control in a "select" if a date is not null?
I have this table:
Table= prestito
+--+--+---+
| Field | Type|
Length|
+--+--
