On Thu, 25 Nov 2004, Andrzej Wojtaszek wrote:
> I'm afraid that operator ::interval not working propertly
> example:
>
> select 1
> ##
> select now() + (1||' day')::interval;
> working propertly
> ##
This is a text -> interval conversion
> select 3
> #
"Andrzej Wojtaszek" <[EMAIL PROTECTED]> writes:
> not working with error "cannot cast type character varying to iterval"
8.0 is more flexible about that, but for the moment use type text
instead of varchar.
regards, tom lane
---(end of broadcast)--
