Re: [GENERAL] Need help creating a function

2000-02-04 Thread Jose Soares
create function money(float8) returns money as ' declare f2 float8; m money; i2 int2; i1 int4; txt text; begin if $1 isnull then return NULL; end if; --integer part... i1:= dtrunc($1); -- decimal part..

[GENERAL] Need help creating a function

2000-02-03 Thread Hitesh Patel
Does anyone have a function laying around that convert a 'money' type to a float8 and return it?