I thought that I had posted my fix for the homepage module,
but I guess that I didn't. Yesterday I upgraded to the 3.2 version on sourceforge. It is in great shape. I still needed to add a few functions to get the homepage, and other modules to work. Here are the two functions that I added:
<![CDATA[
drop function power(int4,int4);
create function power(int4,int4) returns float8 as '
declare
this_power alias for $1;
this_base alias for $2;
base_as_float float8;
power_as_float float8;
return_what float8;
BEGIN
base_as_float := float8(this_base);
power_as_float := float8(this_power);
return_what := pow(power_as_float,base_as_float);
return return_what;
END;
' language 'plpgsql';
drop function trunc(int4);
create function trunc(int4) returns integer as '
declare
my_int alias for $1;
BEGIN
return my_int ;
END;
' language 'plpgsql';
drop function round(int4);
create function round(int4) returns integer as '
declare
my_int alias for $1;
BEGIN
return my_int;
END;
' language 'plpgsql';
]]>
Put these in a file in /doc/sql (with the other datamodel files), and load.
