You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by li...@apache.org on 2017/07/18 09:01:11 UTC
[1/2] incubator-trafodion git commit: [TRAFODION-2355] fix format in
sql reference document
Repository: incubator-trafodion
Updated Branches:
refs/heads/master 485247447 -> 457e20636
[TRAFODION-2355] fix format in sql reference document
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/6fab7690
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/6fab7690
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/6fab7690
Branch: refs/heads/master
Commit: 6fab7690d1a04ef05cfc1fa75594d1826e2c3b92
Parents: a3e19b4
Author: Liu Ming <ov...@sina.com>
Authored: Sat Jul 15 13:42:50 2017 +0000
Committer: Liu Ming <ov...@sina.com>
Committed: Sat Jul 15 13:42:50 2017 +0000
----------------------------------------------------------------------
.../sql_functions_and_expressions.adoc | 142 +++++++++----------
1 file changed, 70 insertions(+), 72 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6fab7690/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc
----------------------------------------------------------------------
diff --git a/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc b/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc
index 1a10040..1dfe031 100644
--- a/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc
+++ b/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc
@@ -253,15 +253,15 @@ returns 0. If value is greater than zero, returns 1.
See the individual entry for the function.
[[encryption_functions]]
- == Encryption Functions
- Use these functions within an SQL value expression to do data encryption or hashing:
+== Encryption Functions
+Use these functions within an SQL value expression to do data encryption or hashing:
- [cols="25%,75%"]
- |===
- | <<md5_function,MD5 Function>> | Returns MD5 checksum
- | <<sha_function,SHA Function>> | Returns SHA-1 160-bit checksum
- | <<sha2_function,SHA2 Function>> | Returns SHA-2 checksum
- |===
+[cols="25%,75%"]
+|===
+| <<md5_function,MD5 Function>> | Returns MD5 checksum
+| <<sha_function,SHA Function>> | Returns SHA-1 160-bit checksum
+| <<sha2_function,SHA2 Function>> | Returns SHA-2 checksum
+|===
[[sequence_functions]]
== Sequence Functions
@@ -3751,71 +3751,69 @@ This function returns 0 for the second input argument, since it is a valid IPV6
-------- -------
1 0
```
+[[inet_aton_function]]
+== INET_ATON Function
+
+Given the dotted-quad representation of an IPv4 network address as a string,
+returns an integer that represents the numeric value of the address in network
+byte order (big endian). INET_ATON() returns NULL if it does not understand its argument.
+
+```
+INET_ATON( expression )
+```
+
+* `_expression_`
++
+specifies an expression that determines the values to include in the
+conversion of the IP address. The _expression_ cannot contain an aggregate
+function or a subquery. If the input value is NULL, INET_ATON returns NULL.
+See <<expressions,Expressions>>.
+
+[[examples_of_inet_aton]]
+=== Examples of INET_ATON
+
+
+```
+>>SELECT INET_ATON('10.0.5.9') from dual;
+
+(EXPR)
+-----------
+167773449
+```
<<<
- +[[inet_aton_function]]
- +== INET_ATON Function
- +
- +Given the dotted-quad representation of an IPv4 network address as a string,
- +returns an integer that represents the numeric value of the address in network
- +byte order (big endian). INET_ATON() returns NULL if it does not understand its argument.
- +
- +```
- +INET_ATON( expression )
- +```
- +
- +* `_expression_`
- ++
- +specifies an expression that determines the values to include in the
- +conversion of the IP address. The _expression_ cannot contain an aggregate
- +function or a subquery. If the input value is NULL, INET_ATON returns NULL.
- +See <<expressions,Expressions>>.
- +
- +[[examples_of_inet_aton]]
- +=== Examples of INET_ATON
- +
- +
- +```
- +>>SELECT INET_ATON('10.0.5.9') from dual;
- +
- +(EXPR)
- +-----------
- +167773449
- +```
- +<<<
- +[[inet_ntoa_function]]
- +== INET_NTOA Function
- +
- +Given a numeric IPv4 network address in network byte order, returns the
- +dotted-quad string representation of the address as a nonbinary string in
- +the connection character set. INET_NTOA() returns NULL if it does
- +not understand its argument.
- +
- +```
- +INET_NTOA( expression )
- +```
- +
- +* `_expression_`
- ++
- +specifies an expression that determines the values to include in the
- +conversion of the number to IP address. The _expression_ cannot contain
- +an aggregate function or a subquery. If the input value is NULL, INET_NTOA
- +returns NULL.
- +See <<expressions,Expressions>>.
- +
- +[[examples_of_inet_ntoa]]
- +=== Examples of INET_NTOA
- +
- +this function will convert an integer into the dotted-quad string
- +representation of the IP address.
- +
- +```
- +>>SELECT INET_NTOA(167773449) from dual
- +
- +(EXPR)
- +-------------
- +'10.0.5.9'
- +```
- +<<<
+[[inet_ntoa_function]]
+== INET_NTOA Function
+
+Given a numeric IPv4 network address in network byte order, returns the
+dotted-quad string representation of the address as a nonbinary string in
+the connection character set. INET_NTOA() returns NULL if it does
+not understand its argument.
+
+```
+INET_NTOA( expression )
+```
+
+* `_expression_`
++
+specifies an expression that determines the values to include in the
+conversion of the number to IP address. The _expression_ cannot contain
+an aggregate function or a subquery. If the input value is NULL, INET_NTOA
+returns NULL.
+See <<expressions,Expressions>>.
+
+[[examples_of_inet_ntoa]]
+=== Examples of INET_NTOA
+
+this function will convert an integer into the dotted-quad string
+representation of the IP address.
+
+```
+>>SELECT INET_NTOA(167773449) from dual
+
+(EXPR)
+-------------
+'10.0.5.9'
+```
[[isnull_function]]
== ISNULL Function
[2/2] incubator-trafodion git commit: Merge Fix for [TRAFODION-2355]
fix format in sql reference document
Posted by li...@apache.org.
Merge Fix for [TRAFODION-2355] fix format in sql reference document
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/457e2063
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/457e2063
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/457e2063
Branch: refs/heads/master
Commit: 457e20636884ab0adb1aec909cf82c22e41cd02f
Parents: 4852474 6fab769
Author: Liu Ming <ov...@sina.com>
Authored: Tue Jul 18 08:59:13 2017 +0000
Committer: Liu Ming <ov...@sina.com>
Committed: Tue Jul 18 08:59:13 2017 +0000
----------------------------------------------------------------------
.../sql_functions_and_expressions.adoc | 142 +++++++++----------
1 file changed, 70 insertions(+), 72 deletions(-)
----------------------------------------------------------------------