Hi,
=20
I'm afraid that operator ::interval not working propertly=20
example:
=20
select 1
######################
select now() + (1||' day')::interval;
working propertly
######################
I have my function writen in plpgsql
function test(varchar) returns varchar;=20
select 2
######################
select my_name,
test('12')
from table1
######################
returns 'aaa', '12 MONTH'=20
working propertly
select 3
######################
select my_name=20
now() + (test('12'))::interval
from table1
######################
not working with error "cannot cast type character varying to iterval"
Facts=20
Database version 7.4.5
psql version 7.4.5
platform PIV
linux : Debian
Regards
Andrzej Wojtaszek
