Repository: incubator-hawq-docs Updated Branches: refs/heads/develop b0ca8aa5a -> ab9161229
udf example - count rows in table, not db 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/73526e7b Tree: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/tree/73526e7b Diff: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/diff/73526e7b Branch: refs/heads/develop Commit: 73526e7b561c27d2b3b917eee6392aa28383ff5b Parents: c321fc5 Author: Lisa Owen <[email protected]> Authored: Thu Oct 27 17:44:30 2016 -0700 Committer: Lisa Owen <[email protected]> Committed: Thu Oct 27 17:44:30 2016 -0700 ---------------------------------------------------------------------- plext/builtin_langs.html.md.erb | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/73526e7b/plext/builtin_langs.html.md.erb ---------------------------------------------------------------------- diff --git a/plext/builtin_langs.html.md.erb b/plext/builtin_langs.html.md.erb index 931f2f2..e98486b 100644 --- a/plext/builtin_langs.html.md.erb +++ b/plext/builtin_langs.html.md.erb @@ -15,7 +15,7 @@ Support for SQL and C language user-defined functions and aliasing of internal f SQL functions execute an arbitrary list of SQL statements. The SQL statements in the body of a SQL function must be separated by semicolons. The final statement in a non-void-returning SQL function must be a [SELECT](../reference/sql/SELECT.html) that returns data of the type specified by the function's return type. The function will return a single or set of rows corresponding to this last SQL query. -The following example creates and calls a SQL function to count the number of rows of the database named `orders`: +The following example creates and calls a SQL function to count the number of rows of the table named `orders`: ``` sql gpadmin=# CREATE FUNCTION count_orders() RETURNS bigint AS $$
