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

From: Dmitry Tkach <dmitry(at)openratings(dot)com>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: mel(at)gmanmi(dot)tv, pgsql-novice(at)postgresql(dot)org
Subject: Re: help: now() + N is now failing!
Date: 2003-07-29 18:28:30
Message-ID: 3F26BCCE.7070008@openratings.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

>
>
>
>

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Stephan Szabo 2003-07-29 18:59:55 Re: help: now() + N is now failing!
Previous Message Robert Treat 2003-07-29 18:27:15 Re: switch statement in plpgsql