Re: help: now() + N is now failing!
| От | Stephan Szabo |
|---|---|
| Тема | Re: help: now() + N is now failing! |
| Дата | |
| Msg-id | 20030729115243.Q94866-100000@megazone.bigpanda.com обсуждение исходный текст |
| Ответ на | Re: help: now() + N is now failing! (Dmitry Tkach <dmitry@openratings.com>) |
| Список | 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 по дате отправления: