interval conversion bug

From: "Andrzej Wojtaszek" <Andrzej(dot)Wojtaszek(at)pro-futuro(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: interval conversion bug
Date: 2004-11-25 07:53:25
Message-ID: s1a59d97.043@poczta.pro-futuro.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Mehul Doshi-A20614 2004-11-25 09:00:52 Installation fails for postgresql-8.0.0-beta4 on WindowsXP SP1
Previous Message Sean Chittenden 2004-11-25 04:53:11 Re: Stack not being popped correctly (was: Re: [HACKERS] plpgsql lacks generic identifier for record in triggers...)