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
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...) |