c user-defined function example - add _c to function name to avoid confusion
Project: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/commit/bd85fdbc Tree: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/tree/bd85fdbc Diff: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/diff/bd85fdbc Branch: refs/heads/develop Commit: bd85fdbc31cb463855c2606fde48d803dccb3de2 Parents: 8e27e90 Author: Lisa Owen <[email protected]> Authored: Wed Oct 5 14:47:11 2016 -0700 Committer: Lisa Owen <[email protected]> Committed: Wed Oct 5 14:47:11 2016 -0700 ---------------------------------------------------------------------- plext/builtin_langs.html.md.erb | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/bd85fdbc/plext/builtin_langs.html.md.erb ---------------------------------------------------------------------- diff --git a/plext/builtin_langs.html.md.erb b/plext/builtin_langs.html.md.erb index 8b408a9..761a1d8 100644 --- a/plext/builtin_langs.html.md.erb +++ b/plext/builtin_langs.html.md.erb @@ -86,11 +86,11 @@ double_it(PG_FUNCTION_ARGS) If the above function is compiled into a shared object named `libdoubleit.so` located in `/share/libs`, you would register and invoke the function with HAWQ as follows: ``` sql -gpadmin=# CREATE FUNCTION double_it(integer) RETURNS integer +gpadmin=# CREATE FUNCTION double_it_c(integer) RETURNS integer AS '/share/libs/libdoubleit', 'double_it' LANGUAGE C STRICT; CREATE FUNCTION -gpadmin=# SELECT double_it(27); +gpadmin=# SELECT double_it_c(27); double_it ----------- 54
