Re: help: now() + N is now failing!

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)

In response to

Responses

Browse pgsql-novice by date

  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!