"zhuge xiao" <[EMAIL PROTECTED]> writes: > I wrote and compiled and linked a C function, add_float, which returns > float in C like following: > > PG_FUNCTION_INFO_V1(add_float); > > Datum > add_float(PG_FUNCTION_ARGS) > { > float arg = PG_GETARG_FLOAT8(0); > > PG_RETURN_FLOAT8(arg + 10); > } > > After having loaded it into database, executed the SQL command, "select > ad_float(2.90)", but one error occured. The error message is "Error: > invalid memory alloc request size 4294967290" .
float8 and float aren't the same thing. "float" is a C data type which is not wide enough to hold a float8. The first line actually works by shortening it but the return doesn't work because it returns a pointer to the float and claims it's a pointer to the float8. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings