Raul,
I have experienced the same problem that you explained previously and I found that when using PG7.2 I could resolve the problem by simply removing an reference to "interval" from the offending file. I don't know what has broken or been changed in PG7.2 from PG7.1.3, but in this instance it completely broke that query.
Here is the code you've listed above that I've replaced. Basically anywhere that an interval is used, I've removed the reference to the interval keyword.
else
if v_archive_date > current_timestamp then
return ''published, archived in ''
|| text(round(extract(days from (v_archive_date -
current_timestamp)) + extract(hours from
(v_archive_date - current_timestamp))/24,1))
|| '' days'';
I've got a seperate file that redefines the entire news__status stored proc if you'd like me to send you a copy.
