| 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: | Whole Thread | Raw Message | 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! |