Thread: combination of 'textcat' and 'interval' in 7.2.
hi, just a day back, i did upgrade to 7.2(from 7.1.2). 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? Would like to get some links on migration of plpgsql functions from 7.1.x to 7.2? Regards, Bhuvaneswar.
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@gmx.net