[
https://issues.apache.org/jira/browse/HAWQ-1096?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15587174#comment-15587174
]
ASF GitHub Bot commented on HAWQ-1096:
--------------------------------------
Github user dyozie commented on a diff in the pull request:
https://github.com/apache/incubator-hawq-docs/pull/25#discussion_r83978174
--- Diff: plext/builtin_langs.html.md.erb ---
@@ -0,0 +1,110 @@
+---
+title: Using HAWQ Built-In Languages
+---
+
+This section provides an introduction to using the HAWQ built-in languages.
+
+HAWQ supports user-defined functions created with the SQL and C built-in
languages. HAWQ also supports user-defined aliases for internal functions.
+
+
+## <a id="enablebuiltin"></a>Enabling Built-in Language Support
+
+Support for SQL, internal, and C language user-defined functions is
enabled by default for all HAWQ databases.
+
+## <a id="builtinsql"></a>SQL
+
+SQL functions execute an arbitrary list of SQL statements. The SQL
statements in the body of an 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 an SQL function to count the
number of rows of the database named `orders`:
+
+``` sql
+gpadmin=# CREATE FUNCTION count_orders() RETURNS bigint AS $$
+ SELECT count(*) FROM orders;
+$$ LANGUAGE SQL;
+CREATE FUNCTION
+gpadmin=# select count_orders();
+ my_count
+----------
+ 830513
+(1 row)
+```
+
+For additional information on creating SQL functions, refer to [Query
Language (SQL)
Functions](https://www.postgresql.org/docs/8.2/static/xfunc-sql.html) in the
PostgreSQL documentation.
+
+## <a id="builtininternal"></a>Internal
--- End diff --
Change title to "Internal Functions"?
> document the HAWQ built-in languages (SQL, C, internal)
> -------------------------------------------------------
>
> Key: HAWQ-1096
> URL: https://issues.apache.org/jira/browse/HAWQ-1096
> Project: Apache HAWQ
> Issue Type: Improvement
> Components: Documentation
> Reporter: Lisa Owen
> Assignee: David Yozie
> Priority: Minor
>
> the HAWQ docs do not discuss the built-in languages supported by HAWQ - SQL,
> C and internal. add content to introduce these languages with relevant
> examples and links.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
