Re: interval conversion bug

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
######################
select my_name,
test('12')
from table1
######################

returns 'aaa', '12 MONTH'

working propertly

select 3
######################
select my_name
now() + (test('12'))::interval
from table1
######################

not working with error "cannot cast type character varying to iterval"

Facts
Database version 7.4.5
psql version 7.4.5
platform PIV
linux : Debian

Regards

Andrzej Wojtaszek

"Andrzej Wojtaszek" <Andrzej(dot)Wojtaszek(at)pro-futuro(dot)com> 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

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
> ######################
> select my_name
> now() + (test('12'))::interval
> from table1
> ######################

This is a varchar -> interval conversion.

It looks like 7.4 doesn't have the latter conversion and requires you to
go through text to make the conversion. 8.0 appears to add direct
conversions from varchar.