Bhuvan A writes:
>
> In my plpgsql functions, i did use(in 7.1.2)
> SELECT INTO <variable> interval(textcat (4, '' hours''));
>
> But now, i do use (in 7.2)
> SELECT INTO <variable> cast (textcat (4, '' hours'') as interval);
>
> and it works.
>
> is this a permanent fix? will it work in earlier and future releases?
Standard syntax is
cast('4' || ' hours' as interval)
--
Peter Eisentraut peter_e(at)gmx(dot)net