interval conversion bug
| От | Andrzej Wojtaszek |
|---|---|
| Тема | interval conversion bug |
| Дата | |
| Msg-id | s1a59d97.043@poczta.pro-futuro.com обсуждение исходный текст |
| Ответы |
Re: interval conversion bug
Re: interval conversion bug |
| Список | pgsql-bugs |
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
В списке pgsql-bugs по дате отправления: