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)--
Hi,
I'm afraid that operator ::interval not working propertly
example:
select 1
##
select now() + (1||' day')::interval;
working propertly
##
I have my function writen in plpgsql
function test(varchar) returns varchar;
select 2
##
