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

From Dmitry Tkach
Subject Re: help: now() + N is now failing!
Date
Msg-id 3F26BCCE.7070008@openratings.com
Whole thread Raw
In response to Re: help: now() + N is now failing!  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Responses Re: help: now() + N is now failing!  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-novice
>
>
>>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...

Dima

>
>
>
>



pgsql-novice by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: help: now() + N is now failing!
Next
From: Robert Treat
Date:
Subject: Re: switch statement in plpgsql