Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group