diff options
Diffstat (limited to 'src/tutorial/funcs.c')
-rw-r--r-- | src/tutorial/funcs.c | 107 |
1 files changed, 0 insertions, 107 deletions
diff --git a/src/tutorial/funcs.c b/src/tutorial/funcs.c deleted file mode 100644 index d2c123a0094..00000000000 --- a/src/tutorial/funcs.c +++ /dev/null @@ -1,107 +0,0 @@ -/****************************************************************************** - These are user-defined functions that can be bound to a Postgres backend - and called by Postgres to execute SQL functions of the same name. - - The calling format for these functions is defined by the CREATE FUNCTION - SQL statement that binds them to the backend. - - NOTE: this file shows examples of "old style" function call conventions. - See funcs_new.c for examples of "new style". -*****************************************************************************/ - -#include "postgres.h" /* general Postgres declarations */ - -#include "executor/executor.h" /* for GetAttributeByName() */ -#include "utils/geo_decls.h" /* for point type */ - - -/* These prototypes just prevent possible warnings from gcc. */ - -int add_one(int arg); -float8 *add_one_float8(float8 *arg); -Point *makepoint(Point *pointx, Point *pointy); -text *copytext(text *t); -text *concat_text(text *arg1, text *arg2); -bool c_overpaid(TupleTableSlot *t, /* the current instance of EMP */ - int32 limit); - - -/* By Value */ - -int -add_one(int arg) -{ - return arg + 1; -} - -/* By Reference, Fixed Length */ - -float8 * -add_one_float8(float8 *arg) -{ - float8 *result = (float8 *) palloc(sizeof(float8)); - - *result = *arg + 1.0; - - return result; -} - -Point * -makepoint(Point *pointx, Point *pointy) -{ - Point *new_point = (Point *) palloc(sizeof(Point)); - - new_point->x = pointx->x; - new_point->y = pointy->y; - - return new_point; -} - -/* By Reference, Variable Length */ - -text * -copytext(text *t) -{ - /* - * VARSIZE is the total size of the struct in bytes. - */ - text *new_t = (text *) palloc(VARSIZE(t)); - - VARATT_SIZEP(new_t) = VARSIZE(t); - - /* - * VARDATA is a pointer to the data region of the struct. - */ - memcpy((void *) VARDATA(new_t), /* destination */ - (void *) VARDATA(t), /* source */ - VARSIZE(t) - VARHDRSZ); /* how many bytes */ - return new_t; -} - -text * -concat_text(text *arg1, text *arg2) -{ - int32 new_text_size = VARSIZE(arg1) + VARSIZE(arg2) - VARHDRSZ; - text *new_text = (text *) palloc(new_text_size); - - memset((void *) new_text, 0, new_text_size); - VARATT_SIZEP(new_text) = new_text_size; - strncpy(VARDATA(new_text), VARDATA(arg1), VARSIZE(arg1) - VARHDRSZ); - strncat(VARDATA(new_text), VARDATA(arg2), VARSIZE(arg2) - VARHDRSZ); - return new_text; -} - -/* Composite types */ - -bool -c_overpaid(TupleTableSlot *t, /* the current instance of EMP */ - int32 limit) -{ - bool isnull; - int32 salary; - - salary = DatumGetInt32(GetAttributeByName(t, "salary", &isnull)); - if (isnull) - return (false); - return salary > limit; -} |