Re: help: now() + N is now failing! - Mailing list pgsql-novice

From Stephan Szabo
Subject Re: help: now() + N is now failing!
Date
Msg-id 20030729115243.Q94866-100000@megazone.bigpanda.com
Whole thread Raw
In response to Re: help: now() + N is now failing!  (Dmitry Tkach <dmitry@openratings.com>)
List pgsql-novice
On Tue, 29 Jul 2003, Dmitry Tkach wrote:

> >
> >
> >>Ok, granted that, but what's wrong with date_pli (now(), 2)?
> >>
> >>
> >
> >It's a similar issue. As a potential counter example, what about
> >date_pli('foo', 2) or date_pli(inet '1.1.1.1', 2)? There's a cast
> >from text->date and a cast inet->text. If you allow downcasts and
> >arbitrary casts you can get some really odd behavior.
> >
> Well... this would be a two-step cast.. That was never allowed (was
> it?), and I never argued that it should...

The first doesn't, date_pli('foo', 2) that's just text->date (the other
does, but it was a more rediculous example using two casts - I don't
see much stretch from allowing all casts implicitly to allowing multiple
casts really in the abstract anyway)


pgsql-novice by date:

Previous
From: Dmitry Tkach
Date:
Subject: Re: help: now() + N is now failing!
Next
From: Dmitry Tkach
Date:
Subject: Re: help: now() + N is now failing!