From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
---|---|
To: | Dmitry Tkach <dmitry(at)openratings(dot)com> |
Cc: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: help: now() + N is now failing! |
Date: | 2003-07-29 18:59:55 |
Message-ID: | 20030729115243.Q94866-100000@megazone.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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)
From | Date | Subject | |
---|---|---|---|
Next Message | Dmitry Tkach | 2003-07-29 19:13:44 | Re: help: now() + N is now failing! |
Previous Message | Dmitry Tkach | 2003-07-29 18:28:30 | Re: help: now() + N is now failing! |