Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Memory Allocation Error


  • From: zhuge xiao <zhuge(at)Rinaix(dot)cn>
  • To: pgsql-bugs(at)postgresql(dot)org
  • Subject: Memory Allocation Error
  • Date: Mon, 24 Sep 2007 12:22:02 +0800
  • Message-id: <46F73B6A.5020606@Rinaix.cn> <text/plain>

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" .

However I changed the above function as following:

PG_FUNCTION_INFO_V1(add_integer);
Datum
add_integer(PG_FUNCTION_ARGS)
{
int32 arg = PG_GETARG_INT32(0);

PG_RETURN_INT32(arg + 10);
}

and executed the SQL command, "select add_integer(5)", and the result is:
add_integer
----------
15

In another word, the function can NOT return float BUT return integer.
Why? Please help me.

Thank you very much.




Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group