In the previous blog we wrote add_two_numbers
function implementation.
file name is add_numbers.c
#include "postgres.h"
#include <string.h>
#include "fmgr.h"
PG_MODULE_MAGIC;
PG_FUNCTION_INFO_V1(add_one);
Datum
add_two_numbers(PG_FUNCTION_ARGS)
{
int32 arg1 = PG_GETARG_INT32(0);
int32 arg2 = PG_GETARG_INT32(1);
PG_RETURN_INT32(arg1 + arg2);
}
Now, let's add this function to age.
save the file in the following path: src/backend/commands
then add the next line to makefile on the top directory of the project
src/backend/commands/add_numbers.o
add this line in OBJS section.
Add the signature to the age--1.3.0.sql at the end of the file
CREATE FUNCTION ag_catalog.add_numbers()
RETURNS Integer
LANGUAGE c
AS 'MODULE_PATHNAME';
then run the following commands in the project directory
sudo make clean PG_CONFIG=/usr/local/pgsql/bin/pg_config
sudo make PG_CONFIG=/usr/local/pgsql/bin/pg_config
sudo make install PG_CONFIG=/usr/local/pgsql/bin/pg_config
Now we are done, after running the postgres server you can use this function as follows
select * from ag_catalog.add_numbers(2,3);
Top comments (0)