http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/e40969b3/docs/2.1.0/sql_reference/index.html ---------------------------------------------------------------------- diff --git a/docs/2.1.0/sql_reference/index.html b/docs/2.1.0/sql_reference/index.html index e5971e6..a2fd6e9 100644 --- a/docs/2.1.0/sql_reference/index.html +++ b/docs/2.1.0/sql_reference/index.html @@ -1457,412 +1457,417 @@ table.CodeRay td.code>pre{padding:0} <li><a href="#examples_of_hour">7.50.3. Examples of HOUR</a></li> </ul> </li> -<li><a href="#insert_function">7.51. INSERT Function</a> +<li><a href="#group_concat_function">7.51. GROUP_CONCAT Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_insert">7.51.1. Examples of INSERT</a></li> +<li><a href="#examples_of_group_concat">7.51.1. Examples of GROUP_CONCAT</a></li> </ul> </li> -<li><a href="#is_ipv4_function">7.52. IS_IPV4 Function</a> +<li><a href="#insert_function">7.52. INSERT Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_is_ipv4">7.52.1. Examples of IS_IPV4</a></li> +<li><a href="#examples_of_insert">7.52.1. Examples of INSERT</a></li> </ul> </li> -<li><a href="#is_ipv6_function">7.53. IS_IPV6 Function</a> +<li><a href="#is_ipv4_function">7.53. IS_IPV4 Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_is_ipv6">7.53.1. Examples of IS_IPV6</a></li> +<li><a href="#examples_of_is_ipv4">7.53.1. Examples of IS_IPV4</a></li> </ul> </li> -<li><a href="#isnull_function">7.54. ISNULL Function</a> +<li><a href="#is_ipv6_function">7.54. IS_IPV6 Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_isnull">7.54.1. Examples of ISNULL</a></li> +<li><a href="#examples_of_is_ipv6">7.54.1. Examples of IS_IPV6</a></li> </ul> </li> -<li><a href="#juliantimestamp_function">7.55. JULIANTIMESTAMP Function</a> +<li><a href="#isnull_function">7.55. ISNULL Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_juliantimestamp">7.55.1. Considerations for JULIANTIMESTAMP</a></li> -<li><a href="#examples_of_juliantimestamp">7.55.2. Examples of JULIANTIMESTAMP</a></li> +<li><a href="#examples_of_isnull">7.55.1. Examples of ISNULL</a></li> </ul> </li> -<li><a href="#lastnotnull_function">7.56. LASTNOTNULL Function</a> +<li><a href="#juliantimestamp_function">7.56. JULIANTIMESTAMP Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_lastnotnull">7.56.1. Examples of LASTNOTNULL</a></li> +<li><a href="#considerations_for_juliantimestamp">7.56.1. Considerations for JULIANTIMESTAMP</a></li> +<li><a href="#examples_of_juliantimestamp">7.56.2. Examples of JULIANTIMESTAMP</a></li> </ul> </li> -<li><a href="#lcase_function">7.57. LCASE Function</a> +<li><a href="#lastnotnull_function">7.57. LASTNOTNULL Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_lcase">7.57.1. Examples of LCASE</a></li> -<li><a href="#left_function">7.57.2. LEFT Function</a></li> -<li><a href="#examples_of_left">7.57.3. Examples of LEFT</a></li> +<li><a href="#examples_of_lastnotnull">7.57.1. Examples of LASTNOTNULL</a></li> </ul> </li> -<li><a href="#locate_function">7.58. LOCATE Function</a> +<li><a href="#lcase_function">7.58. LCASE Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_locate">7.58.1. Considerations for LOCATE</a></li> -<li><a href="#examples_of_locate">7.58.2. Examples of LOCATE</a></li> +<li><a href="#examples_of_lcase">7.58.1. Examples of LCASE</a></li> +<li><a href="#left_function">7.58.2. LEFT Function</a></li> +<li><a href="#examples_of_left">7.58.3. Examples of LEFT</a></li> </ul> </li> -<li><a href="#log_function">7.59. LOG Function</a> +<li><a href="#locate_function">7.59. LOCATE Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_log">7.59.1. Examples of LOG</a></li> -<li><a href="#log10_function">7.59.2. LOG10 Function</a></li> -<li><a href="#examples_of_log10">7.59.3. Examples of LOG10</a></li> +<li><a href="#considerations_for_locate">7.59.1. Considerations for LOCATE</a></li> +<li><a href="#examples_of_locate">7.59.2. Examples of LOCATE</a></li> </ul> </li> -<li><a href="#lower_function">7.60. LOWER Function</a> +<li><a href="#log_function">7.60. LOG Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_lower">7.60.1. Considerations for LOWER</a></li> -<li><a href="#examples_of_lower">7.60.2. Examples of LOWER</a></li> -<li><a href="#lpad_function">7.60.3. LPAD Function</a></li> -<li><a href="#examples_of_lpad">7.60.4. Examples of LPAD</a></li> +<li><a href="#examples_of_log">7.60.1. Examples of LOG</a></li> +<li><a href="#log10_function">7.60.2. LOG10 Function</a></li> +<li><a href="#examples_of_log10">7.60.3. Examples of LOG10</a></li> </ul> </li> -<li><a href="#ltrim_function">7.61. LTRIM Function</a> +<li><a href="#lower_function">7.61. LOWER Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_ltrim">7.61.1. Considerations for LTRIM</a></li> -<li><a href="#examples_of_ltrim">7.61.2. Examples of LTRIM</a></li> +<li><a href="#considerations_for_lower">7.61.1. Considerations for LOWER</a></li> +<li><a href="#examples_of_lower">7.61.2. Examples of LOWER</a></li> +<li><a href="#lpad_function">7.61.3. LPAD Function</a></li> +<li><a href="#examples_of_lpad">7.61.4. Examples of LPAD</a></li> </ul> </li> -<li><a href="#max_function">7.62. MAX/MAXIMUM Function</a> +<li><a href="#ltrim_function">7.62. LTRIM Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_max">7.62.1. Considerations for MAX/MAXIMUM</a></li> -<li><a href="#operands_of_the_expression">7.62.2. Operands of the Expression</a></li> -<li><a href="#examples_of_max">7.62.3. Examples of MAX/MAXIMUM</a></li> +<li><a href="#considerations_for_ltrim">7.62.1. Considerations for LTRIM</a></li> +<li><a href="#examples_of_ltrim">7.62.2. Examples of LTRIM</a></li> </ul> </li> -<li><a href="#md5_function">7.63. MD5 Function</a> +<li><a href="#max_function">7.63. MAX/MAXIMUM Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_md5">7.63.1. Examples of MD5</a></li> +<li><a href="#considerations_for_max">7.63.1. Considerations for MAX/MAXIMUM</a></li> +<li><a href="#operands_of_the_expression">7.63.2. Operands of the Expression</a></li> +<li><a href="#examples_of_max">7.63.3. Examples of MAX/MAXIMUM</a></li> </ul> </li> -<li><a href="#min_function">7.64. MIN Function</a> +<li><a href="#md5_function">7.64. MD5 Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_min">7.64.1. Considerations for MIN</a></li> -<li><a href="#examples_of_min">7.64.2. Examples of MIN</a></li> +<li><a href="#examples_of_md5">7.64.1. Examples of MD5</a></li> </ul> </li> -<li><a href="#minute_function">7.65. MINUTE Function</a> +<li><a href="#min_function">7.65. MIN Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_minute">7.65.1. Examples of minute</a></li> +<li><a href="#considerations_for_min">7.65.1. Considerations for MIN</a></li> +<li><a href="#examples_of_min">7.65.2. Examples of MIN</a></li> </ul> </li> -<li><a href="#mod_function">7.66. MOD Function</a> +<li><a href="#minute_function">7.66. MINUTE Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_mod">7.66.1. Examples of MOD</a></li> +<li><a href="#examples_of_minute">7.66.1. Examples of minute</a></li> </ul> </li> -<li><a href="#month_function">7.67. MONTH Function</a> +<li><a href="#mod_function">7.67. MOD Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_month">7.67.1. Examples of MONTH</a></li> +<li><a href="#examples_of_mod">7.67.1. Examples of MOD</a></li> </ul> </li> -<li><a href="#monthname_function">7.68. MONTHNAME Function</a> +<li><a href="#month_function">7.68. MONTH Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_monthname">7.68.1. Considerations for MONTHNAME</a></li> -<li><a href="#examples_of_monthname">7.68.2. Examples of MONTHNAME</a></li> +<li><a href="#examples_of_month">7.68.1. Examples of MONTH</a></li> </ul> </li> -<li><a href="#movingavg_function">7.69. MOVINGAVG Function</a> +<li><a href="#monthname_function">7.69. MONTHNAME Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_movingavg">7.69.1. Examples of MOVINGAVG</a></li> +<li><a href="#considerations_for_monthname">7.69.1. Considerations for MONTHNAME</a></li> +<li><a href="#examples_of_monthname">7.69.2. Examples of MONTHNAME</a></li> </ul> </li> -<li><a href="#movingcount_function">7.70. MOVINGCOUNT Function</a> +<li><a href="#movingavg_function">7.70. MOVINGAVG Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_movingcount">7.70.1. Considerations for MOVINGCOUNT</a></li> -<li><a href="#examples_of_movingcount">7.70.2. Examples of MOVINGCOUNT</a></li> +<li><a href="#examples_of_movingavg">7.70.1. Examples of MOVINGAVG</a></li> </ul> </li> -<li><a href="#movingmax_function">7.71. MOVINGMAX Function</a> +<li><a href="#movingcount_function">7.71. MOVINGCOUNT Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_movingmax">7.71.1. Examples of MOVINGMAX</a></li> +<li><a href="#considerations_for_movingcount">7.71.1. Considerations for MOVINGCOUNT</a></li> +<li><a href="#examples_of_movingcount">7.71.2. Examples of MOVINGCOUNT</a></li> </ul> </li> -<li><a href="#movingmin_function">7.72. MOVINGMIN Function</a> +<li><a href="#movingmax_function">7.72. MOVINGMAX Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_movingmin">7.72.1. Examples of MOVINGMIN</a></li> +<li><a href="#examples_of_movingmax">7.72.1. Examples of MOVINGMAX</a></li> </ul> </li> -<li><a href="#movingstddev_function">7.73. MOVINGSTDDEV Function</a> +<li><a href="#movingmin_function">7.73. MOVINGMIN Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_movingstddev">7.73.1. Examples of MOVINGSTDDEV</a></li> +<li><a href="#examples_of_movingmin">7.73.1. Examples of MOVINGMIN</a></li> </ul> </li> -<li><a href="#movingsum_function">7.74. MOVINGSUM Function</a> +<li><a href="#movingstddev_function">7.74. MOVINGSTDDEV Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_movingsum">7.74.1. Examples of MOVINGSUM</a></li> +<li><a href="#examples_of_movingstddev">7.74.1. Examples of MOVINGSTDDEV</a></li> </ul> </li> -<li><a href="#movingvariance_function">7.75. MOVINGVARIANCE Function</a> +<li><a href="#movingsum_function">7.75. MOVINGSUM Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_movingvariance">7.75.1. Examples of MOVINGVARIANCE</a></li> -<li><a href="#nullif_function">7.75.2. NULLIF Function</a></li> -<li><a href="#examples_of_nullif">7.75.3. Examples of NULLIF</a></li> +<li><a href="#examples_of_movingsum">7.75.1. Examples of MOVINGSUM</a></li> </ul> </li> -<li><a href="#nullifzero_function">7.76. NULLIFZERO Function</a> +<li><a href="#movingvariance_function">7.76. MOVINGVARIANCE Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_nullifzero">7.76.1. Examples of NULLIFZERO</a></li> +<li><a href="#examples_of_movingvariance">7.76.1. Examples of MOVINGVARIANCE</a></li> +<li><a href="#nullif_function">7.76.2. NULLIF Function</a></li> +<li><a href="#examples_of_nullif">7.76.3. Examples of NULLIF</a></li> </ul> </li> -<li><a href="#nvl_function">7.77. NVL Function</a> +<li><a href="#nullifzero_function">7.77. NULLIFZERO Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_nvl">7.77.1. Examples of NVL</a></li> +<li><a href="#examples_of_nullifzero">7.77.1. Examples of NULLIFZERO</a></li> </ul> </li> -<li><a href="#octet_length_function">7.78. OCTET_LENGTH Function</a> +<li><a href="#nvl_function">7.78. NVL Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_octet_length">7.78.1. Considerations for OCTET_LENGTH</a></li> -<li><a href="#offset_function">7.78.2. OFFSET Function</a></li> -<li><a href="#examples_of_offset">7.78.3. Examples of OFFSET</a></li> +<li><a href="#examples_of_nvl">7.78.1. Examples of NVL</a></li> </ul> </li> -<li><a href="#pi_function">7.79. PI Function</a> +<li><a href="#octet_length_function">7.79. OCTET_LENGTH Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_pi">7.79.1. Examples of PI</a></li> +<li><a href="#considerations_for_octet_length">7.79.1. Considerations for OCTET_LENGTH</a></li> +<li><a href="#offset_function">7.79.2. OFFSET Function</a></li> +<li><a href="#examples_of_offset">7.79.3. Examples of OFFSET</a></li> </ul> </li> -<li><a href="#position_function">7.80. POSITION Function</a> +<li><a href="#pi_function">7.80. PI Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_position">7.80.1. Considerations for POSITION</a></li> -<li><a href="#examples_of_position">7.80.2. Examples of POSITION</a></li> +<li><a href="#examples_of_pi">7.80.1. Examples of PI</a></li> </ul> </li> -<li><a href="#power_function">7.81. POWER Function</a> +<li><a href="#position_function">7.81. POSITION Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_power">7.81.1. Examples of POWER</a></li> +<li><a href="#considerations_for_position">7.81.1. Considerations for POSITION</a></li> +<li><a href="#examples_of_position">7.81.2. Examples of POSITION</a></li> </ul> </li> -<li><a href="#quarter_function">7.82. QUARTER Function</a> +<li><a href="#power_function">7.82. POWER Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_quarter">7.82.1. Examples of QUARTER</a></li> +<li><a href="#examples_of_power">7.82.1. Examples of POWER</a></li> </ul> </li> -<li><a href="#radians_function">7.83. RADIANS Function</a> +<li><a href="#quarter_function">7.83. QUARTER Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_radians">7.83.1. Examples of RADIANS</a></li> +<li><a href="#examples_of_quarter">7.83.1. Examples of QUARTER</a></li> </ul> </li> -<li><a href="#runningrank_function">7.84. RANK/RUNNINGRANK Function</a> +<li><a href="#radians_function">7.84. RADIANS Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_runningrank">7.84.1. Considerations for RANK/RUNNINGRANK</a></li> -<li><a href="#examples_of_runningrank">7.84.2. Examples of RANK/RUNNINGRANK</a></li> +<li><a href="#examples_of_radians">7.84.1. Examples of RADIANS</a></li> </ul> </li> -<li><a href="#repeat_function">7.85. REPEAT Function</a> +<li><a href="#runningrank_function">7.85. RANK/RUNNINGRANK Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_repeat">7.85.1. Examples of REPEAT</a></li> +<li><a href="#considerations_for_runningrank">7.85.1. Considerations for RANK/RUNNINGRANK</a></li> +<li><a href="#examples_of_runningrank">7.85.2. Examples of RANK/RUNNINGRANK</a></li> </ul> </li> -<li><a href="#replace_function">7.86. REPLACE Function</a> +<li><a href="#repeat_function">7.86. REPEAT Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_replace">7.86.1. Examples of REPLACE</a></li> +<li><a href="#examples_of_repeat">7.86.1. Examples of REPEAT</a></li> </ul> </li> -<li><a href="#right_function">7.87. RIGHT Function</a> +<li><a href="#replace_function">7.87. REPLACE Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_right">7.87.1. Examples of RIGHT</a></li> +<li><a href="#examples_of_replace">7.87.1. Examples of REPLACE</a></li> </ul> </li> -<li><a href="#round_function">7.88. ROUND Function</a> +<li><a href="#right_function">7.88. RIGHT Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_round">7.88.1. Examples of ROUND</a></li> +<li><a href="#examples_of_right">7.88.1. Examples of RIGHT</a></li> </ul> </li> -<li><a href="#rows_since_function">7.89. ROWS SINCE Function</a> +<li><a href="#round_function">7.89. ROUND Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_rows_since">7.89.1. Considerations for ROWS SINCE</a></li> -<li><a href="#examples_of_rows_since">7.89.2. Examples of ROWS SINCE</a></li> +<li><a href="#examples_of_round">7.89.1. Examples of ROUND</a></li> </ul> </li> -<li><a href="#rows_since_changed_function">7.90. ROWS SINCE CHANGED Function</a> +<li><a href="#rows_since_function">7.90. ROWS SINCE Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_rows_since_changed">7.90.1. Considerations for ROWS SINCE CHANGED</a></li> -<li><a href="#examples_of_rows_since_changed">7.90.2. Examples of ROWS SINCE CHANGED</a></li> +<li><a href="#considerations_for_rows_since">7.90.1. Considerations for ROWS SINCE</a></li> +<li><a href="#examples_of_rows_since">7.90.2. Examples of ROWS SINCE</a></li> </ul> </li> -<li><a href="#rpad_function">7.91. RPAD Function</a> +<li><a href="#rows_since_changed_function">7.91. ROWS SINCE CHANGED Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_rpad_function">7.91.1. Examples of RPAD Function</a></li> +<li><a href="#considerations_for_rows_since_changed">7.91.1. Considerations for ROWS SINCE CHANGED</a></li> +<li><a href="#examples_of_rows_since_changed">7.91.2. Examples of ROWS SINCE CHANGED</a></li> </ul> </li> -<li><a href="#rtrim_function">7.92. RTRIM Function</a> +<li><a href="#rpad_function">7.92. RPAD Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_rtrim">7.92.1. Considerations for RTRIM</a></li> -<li><a href="#examples_of_rtrim">7.92.2. Examples of RTRIM</a></li> +<li><a href="#examples_of_rpad_function">7.92.1. Examples of RPAD Function</a></li> </ul> </li> -<li><a href="#runningavg_function">7.93. RUNNINGAVG Function</a> +<li><a href="#rtrim_function">7.93. RTRIM Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_runningavg">7.93.1. Considerations for RUNNINGAVG</a></li> -<li><a href="#examples_of_runningavg">7.93.2. Examples of RUNNINGAVG</a></li> +<li><a href="#considerations_for_rtrim">7.93.1. Considerations for RTRIM</a></li> +<li><a href="#examples_of_rtrim">7.93.2. Examples of RTRIM</a></li> </ul> </li> -<li><a href="#runningcount_function">7.94. RUNNINGCOUNT Function</a> +<li><a href="#runningavg_function">7.94. RUNNINGAVG Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_runningcount">7.94.1. Considerations for RUNNINGCOUNT</a></li> -<li><a href="#examples_of_runningcount">7.94.2. Examples of RUNNINGCOUNT</a></li> +<li><a href="#considerations_for_runningavg">7.94.1. Considerations for RUNNINGAVG</a></li> +<li><a href="#examples_of_runningavg">7.94.2. Examples of RUNNINGAVG</a></li> </ul> </li> -<li><a href="#runningmax_function">7.95. RUNNINGMAX Function</a> +<li><a href="#runningcount_function">7.95. RUNNINGCOUNT Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_runningmax">7.95.1. Examples of RUNNINGMAX</a></li> +<li><a href="#considerations_for_runningcount">7.95.1. Considerations for RUNNINGCOUNT</a></li> +<li><a href="#examples_of_runningcount">7.95.2. Examples of RUNNINGCOUNT</a></li> </ul> </li> -<li><a href="#runningmin_function">7.96. RUNNINGMIN Function</a> +<li><a href="#runningmax_function">7.96. RUNNINGMAX Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_runningmin">7.96.1. Examples of RUNNINGMIN</a></li> -<li><a href="#runningstddev_function">7.96.2. RUNNINGSTDDEV Function</a></li> -<li><a href="#considerations_for_runningstddev">7.96.3. Considerations for RUNNINGSTDDEV</a></li> -<li><a href="#examples_of_runningstddev">7.96.4. Examples of RUNNINGSTDDEV</a></li> +<li><a href="#examples_of_runningmax">7.96.1. Examples of RUNNINGMAX</a></li> </ul> </li> -<li><a href="#runningsum_function">7.97. RUNNINGSUM Function</a> +<li><a href="#runningmin_function">7.97. RUNNINGMIN Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_runningsum">7.97.1. Examples of RUNNINGSUM</a></li> +<li><a href="#examples_of_runningmin">7.97.1. Examples of RUNNINGMIN</a></li> +<li><a href="#runningstddev_function">7.97.2. RUNNINGSTDDEV Function</a></li> +<li><a href="#considerations_for_runningstddev">7.97.3. Considerations for RUNNINGSTDDEV</a></li> +<li><a href="#examples_of_runningstddev">7.97.4. Examples of RUNNINGSTDDEV</a></li> </ul> </li> -<li><a href="#runningvariance_function">7.98. RUNNINGVARIANCE Function</a> +<li><a href="#runningsum_function">7.98. RUNNINGSUM Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_runningvariance">7.98.1. Examples of RUNNINGVARIANCE</a></li> +<li><a href="#examples_of_runningsum">7.98.1. Examples of RUNNINGSUM</a></li> </ul> </li> -<li><a href="#second_function">7.99. SECOND Function</a> +<li><a href="#runningvariance_function">7.99. RUNNINGVARIANCE Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_second">7.99.1. Examples of SECOND</a></li> +<li><a href="#examples_of_runningvariance">7.99.1. Examples of RUNNINGVARIANCE</a></li> </ul> </li> -<li><a href="#sha_function">7.100. SHA Function</a> +<li><a href="#second_function">7.100. SECOND Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_sha">7.100.1. examples of SHA</a></li> +<li><a href="#examples_of_second">7.100.1. Examples of SECOND</a></li> </ul> </li> -<li><a href="#sha2_function">7.101. SHA2 Function</a> +<li><a href="#sha_function">7.101. SHA Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_sha2">7.101.1. examples of SHA2</a></li> +<li><a href="#examples_of_sha">7.101.1. examples of SHA</a></li> </ul> </li> -<li><a href="#sign_function">7.102. SIGN Function</a> +<li><a href="#sha2_function">7.102. SHA2 Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_sign">7.102.1. Examples of SIGN</a></li> +<li><a href="#examples_of_sha2">7.102.1. examples of SHA2</a></li> </ul> </li> -<li><a href="#sin_function">7.103. SIN Function</a> +<li><a href="#sign_function">7.103. SIGN Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_sin">7.103.1. Examples of SIN</a></li> +<li><a href="#examples_of_sign">7.103.1. Examples of SIGN</a></li> </ul> </li> -<li><a href="#sinh_function">7.104. SINH Function</a> +<li><a href="#sin_function">7.104. SIN Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_sinh">7.104.1. Examples of SINH</a></li> -<li><a href="#space_function">7.104.2. SPACE Function</a></li> -<li><a href="#examples_of_space">7.104.3. Examples of SPACE</a></li> +<li><a href="#examples_of_sin">7.104.1. Examples of SIN</a></li> </ul> </li> -<li><a href="#sqrt_function">7.105. SQRT Function</a> +<li><a href="#sinh_function">7.105. SINH Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_sqrt">7.105.1. Examples of SQRT</a></li> +<li><a href="#examples_of_sinh">7.105.1. Examples of SINH</a></li> +<li><a href="#space_function">7.105.2. SPACE Function</a></li> +<li><a href="#examples_of_space">7.105.3. Examples of SPACE</a></li> </ul> </li> -<li><a href="#stddev_function">7.106. STDDEV Function</a> +<li><a href="#sqrt_function">7.106. SQRT Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_stddev">7.106.1. Considerations for STDDEV</a></li> -<li><a href="#examples_of_stddev">7.106.2. Examples of STDDEV</a></li> +<li><a href="#examples_of_sqrt">7.106.1. Examples of SQRT</a></li> </ul> </li> -<li><a href="#substring_function">7.107. SUBSTRING/SUBSTR Function</a> +<li><a href="#stddev_function">7.107. STDDEV Function</a> <ul class="sectlevel3"> -<li><a href="#alternative_forms">7.107.1. Alternative Forms</a></li> -<li><a href="#considerations_for_substring">7.107.2. Considerations for SUBSTRING/SUBSTR</a></li> -<li><a href="#examples_of_substring">7.107.3. Examples of SUBSTRING/SUBSTR</a></li> +<li><a href="#considerations_for_stddev">7.107.1. Considerations for STDDEV</a></li> +<li><a href="#examples_of_stddev">7.107.2. Examples of STDDEV</a></li> </ul> </li> -<li><a href="#sum_function">7.108. SUM Function</a> +<li><a href="#substring_function">7.108. SUBSTRING/SUBSTR Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_sum">7.108.1. Considerations for SUM</a></li> -<li><a href="#examples_of_sum">7.108.2. Examples of SUM</a></li> +<li><a href="#alternative_forms">7.108.1. Alternative Forms</a></li> +<li><a href="#considerations_for_substring">7.108.2. Considerations for SUBSTRING/SUBSTR</a></li> +<li><a href="#examples_of_substring">7.108.3. Examples of SUBSTRING/SUBSTR</a></li> </ul> </li> -<li><a href="#tan_function">7.109. TAN Function</a> +<li><a href="#sum_function">7.109. SUM Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_tan">7.109.1. Examples of TAN</a></li> -<li><a href="#tanh_function">7.109.2. TANH Function</a></li> -<li><a href="#examples_of_tanh">7.109.3. Examples of TANH</a></li> +<li><a href="#considerations_for_sum">7.109.1. Considerations for SUM</a></li> +<li><a href="#examples_of_sum">7.109.2. Examples of SUM</a></li> </ul> </li> -<li><a href="#this_function">7.110. THIS Function</a> +<li><a href="#tan_function">7.110. TAN Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_this">7.110.1. Considerations for THIS</a></li> -<li><a href="#examples_of_this">7.110.2. Examples of THIS</a></li> +<li><a href="#examples_of_tan">7.110.1. Examples of TAN</a></li> +<li><a href="#tanh_function">7.110.2. TANH Function</a></li> +<li><a href="#examples_of_tanh">7.110.3. Examples of TANH</a></li> </ul> </li> -<li><a href="#timestampadd_function">7.111. TIMESTAMPADD Function</a> +<li><a href="#this_function">7.111. THIS Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_timestampadd">7.111.1. Examples of TIMESTAMPADD</a></li> +<li><a href="#considerations_for_this">7.111.1. Considerations for THIS</a></li> +<li><a href="#examples_of_this">7.111.2. Examples of THIS</a></li> </ul> </li> -<li><a href="#timestampdiff_function">7.112. TIMESTAMPDIFF Function</a> +<li><a href="#timestampadd_function">7.112. TIMESTAMPADD Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_timestampdiff">7.112.1. Examples of TIMESTAMPDIFF</a></li> +<li><a href="#examples_of_timestampadd">7.112.1. Examples of TIMESTAMPADD</a></li> </ul> </li> -<li><a href="#to_date_function">7.113. TO_DATE Function</a> +<li><a href="#timestampdiff_function">7.113. TIMESTAMPDIFF Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_to_date">7.113.1. Considerations for TO_DATE</a></li> -<li><a href="#examples_of_to_date">7.113.2. Examples of TO_DATE</a></li> +<li><a href="#examples_of_timestampdiff">7.113.1. Examples of TIMESTAMPDIFF</a></li> </ul> </li> -<li><a href="#to_time_function">7.114. TO_TIME Function</a> +<li><a href="#to_date_function">7.114. TO_DATE Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_to_time">7.114.1. Examples of TO_TIME</a></li> +<li><a href="#considerations_for_to_date">7.114.1. Considerations for TO_DATE</a></li> +<li><a href="#examples_of_to_date">7.114.2. Examples of TO_DATE</a></li> </ul> </li> -<li><a href="#to_timestamp_function">7.115. TO_TIMESTAMP Function</a> +<li><a href="#to_time_function">7.115. TO_TIME Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_to_timestamp">7.115.1. Example of TO_TIMESTAMP</a></li> +<li><a href="#examples_of_to_time">7.115.1. Examples of TO_TIME</a></li> </ul> </li> -<li><a href="#translate_function">7.116. TRANSLATE Function</a></li> -<li><a href="#trim_function">7.117. TRIM Function</a> +<li><a href="#to_timestamp_function">7.116. TO_TIMESTAMP Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_trim">7.117.1. Considerations for TRIM</a></li> -<li><a href="#examples_of_trim">7.117.2. Examples of TRIM</a></li> +<li><a href="#examples_of_to_timestamp">7.116.1. Example of TO_TIMESTAMP</a></li> </ul> </li> -<li><a href="#ucase_function">7.118. UCASE Function</a> +<li><a href="#translate_function">7.117. TRANSLATE Function</a></li> +<li><a href="#trim_function">7.118. TRIM Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_ucase">7.118.1. Considerations for UCASE</a></li> -<li><a href="#examples_of_ucase">7.118.2. Examples of UCASE</a></li> -<li><a href="#upper_function">7.118.3. UPPER Function</a></li> -<li><a href="#examples_of_upper">7.118.4. Examples of UPPER</a></li> -<li><a href="#upshift_function">7.118.5. UPSHIFT Function</a></li> -<li><a href="#examples_of_upshift">7.118.6. Examples of UPSHIFT</a></li> +<li><a href="#considerations_for_trim">7.118.1. Considerations for TRIM</a></li> +<li><a href="#examples_of_trim">7.118.2. Examples of TRIM</a></li> </ul> </li> -<li><a href="#user_function">7.119. USER Function</a> +<li><a href="#ucase_function">7.119. UCASE Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_user">7.119.1. Considerations for USER</a></li> -<li><a href="#examples_of_user">7.119.2. Examples of USER</a></li> +<li><a href="#considerations_for_ucase">7.119.1. Considerations for UCASE</a></li> +<li><a href="#examples_of_ucase">7.119.2. Examples of UCASE</a></li> +<li><a href="#upper_function">7.119.3. UPPER Function</a></li> +<li><a href="#examples_of_upper">7.119.4. Examples of UPPER</a></li> +<li><a href="#upshift_function">7.119.5. UPSHIFT Function</a></li> +<li><a href="#examples_of_upshift">7.119.6. Examples of UPSHIFT</a></li> </ul> </li> -<li><a href="#variance_function">7.120. VARIANCE Function</a> +<li><a href="#user_function">7.120. USER Function</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_variance">7.120.1. Considerations for VARIANCE</a></li> -<li><a href="#examples_of_variance">7.120.2. Examples of VARIANCE</a></li> +<li><a href="#considerations_for_user">7.120.1. Considerations for USER</a></li> +<li><a href="#examples_of_user">7.120.2. Examples of USER</a></li> </ul> </li> -<li><a href="#week_function">7.121. WEEK Function</a> +<li><a href="#variance_function">7.121. VARIANCE Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_week">7.121.1. Examples of WEEK</a></li> +<li><a href="#considerations_for_variance">7.121.1. Considerations for VARIANCE</a></li> +<li><a href="#examples_of_variance">7.121.2. Examples of VARIANCE</a></li> </ul> </li> -<li><a href="#year_function">7.122. YEAR Function</a> +<li><a href="#week_function">7.122. WEEK Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_year">7.122.1. Examples of YEAR</a></li> +<li><a href="#examples_of_week">7.122.1. Examples of WEEK</a></li> </ul> </li> -<li><a href="#zeroifnull_function">7.123. ZEROIFNULL Function</a> +<li><a href="#year_function">7.123. YEAR Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_zeroifnull">7.123.1. Examples of ZEROIFNULL</a></li> +<li><a href="#examples_of_year">7.123.1. Examples of YEAR</a></li> +</ul> +</li> +<li><a href="#zeroifnull_function">7.124. ZEROIFNULL Function</a> +<ul class="sectlevel3"> +<li><a href="#examples_of_zeroifnull">7.124.1. Examples of ZEROIFNULL</a></li> </ul> </li> </ul> @@ -26489,6 +26494,11 @@ table derived from the expression argument of the function (optionally distinct values).</p></td> </tr> <tr> +<td class="tableblock halign-left valign-top"><p class="tableblock"><a href="#group_concat_function">GROUP_CONCAT Function</a></p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">This function returns a string result with the concatenated non-NULL +values from a group.</p></td> +</tr> +<tr> <td class="tableblock halign-left valign-top"><p class="tableblock"><a href="#max_function">MAX/MAXIMUM Function</a></p></td> <td class="tableblock halign-left valign-top"><p class="tableblock">Determines a maximum value from the group of values derived from the evaluation of the expression argument.</p></td> @@ -31758,7 +31768,53 @@ Start/Date Time/Shipped (EXPR) </div> </div> <div class="sect2"> -<h3 id="insert_function">7.51. INSERT Function</h3> +<h3 id="group_concat_function">7.51. GROUP_CONCAT Function</h3> +<div class="paragraph"> +<p>This function returns a string result with the concatenated non-NULL values from a group. +It returns NULL if there are no non-NULL values. +The syntax is as follows:</p> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">GROUP_CONCAT([DISTINCT] expr [,expr ...] + [ORDER BY {unsigned_integer | col_name | expr} + [ASC | DESC] [,col_name ...]] + [SEPARATOR str_val])</code></pre> +</div> +</div> +<div class="paragraph"> +<p>Get the concatenated values of expression combinations. To eliminate duplicate values, +use the DISTINCT clause. +To sort values in the result, use the ORDER BY clause. To sort in reverse order, add +the DESC (descending) keyword to the name of the column you are sorting by in the +ORDER BY clause. The default is ascending order; this may be specified explicitly using +the ASC keyword. The default separator between values in a group is comma (,). To specify +a separator explicitly, use SEPARATOR followed by the string literal value that should be +inserted between group values. To eliminate the separator altogether, specify SEPARATOR ''.</p> +</div> +<div class="sect3"> +<h4 id="examples_of_group_concat">7.51.1. Examples of GROUP_CONCAT</h4> +<div class="paragraph"> +<p>The following example returns concatenated strings for column test_score for each student.</p> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">>> SELECT student_name, + GROUP_CONCAT(DISTINCT test_score + ORDER BY test_score DESC SEPARATOR ' ') + FROM student + GROUP BY student_name; +STUDENT_NAME (EXPR) +-------------- -------------- +scott 91 90 80 56 +tom 91 77 43</code></pre> +</div> +</div> +<div style="page-break-after: always;"></div> +</div> +</div> +<div class="sect2"> +<h3 id="insert_function">7.52. INSERT Function</h3> <div class="paragraph"> <p>The INSERT function returns a character string where a specified number of characters within the character string has been deleted, beginning at @@ -31808,7 +31864,7 @@ or equal to the length of <em>char-expr-1</em>.</p> </ul> </div> <div class="sect3"> -<h4 id="examples_of_insert">7.51.1. Examples of INSERT</h4> +<h4 id="examples_of_insert">7.52.1. Examples of INSERT</h4> <div class="ulist"> <ul> <li> @@ -31842,7 +31898,7 @@ SALES REP </div> </div> <div class="sect2"> -<h3 id="is_ipv4_function">7.52. IS_IPV4 Function</h3> +<h3 id="is_ipv4_function">7.53. IS_IPV4 Function</h3> <div class="paragraph"> <p>For a given argument, if it is a valid IPV4 string, IS_IPV4() returns 1 else returns 0.</p> </div> @@ -31865,7 +31921,7 @@ See <a href="#expressions">Expressions</a>.</p> </ul> </div> <div class="sect3"> -<h4 id="examples_of_is_ipv4">7.52.1. Examples of IS_IPV4</h4> +<h4 id="examples_of_is_ipv4">7.53.1. Examples of IS_IPV4</h4> <div class="paragraph"> <p>This function returns 1 for the first input argument, since it is a valid IPV4 string; 0 for the second input argument, since it is an invalid IPV4 string.</p> @@ -31883,7 +31939,7 @@ See <a href="#expressions">Expressions</a>.</p> </div> </div> <div class="sect2"> -<h3 id="is_ipv6_function">7.53. IS_IPV6 Function</h3> +<h3 id="is_ipv6_function">7.54. IS_IPV6 Function</h3> <div class="paragraph"> <p>Returns 1 if the argument is a valid IPv6 address specified as a string, 0 otherwise. This function does not consider IPv4 addresses to be valid IPv6 addresses.</p> @@ -31907,7 +31963,7 @@ See <a href="#expressions">Expressions</a>.</p> </ul> </div> <div class="sect3"> -<h4 id="examples_of_is_ipv6">7.53.1. Examples of IS_IPV6</h4> +<h4 id="examples_of_is_ipv6">7.54.1. Examples of IS_IPV6</h4> <div class="paragraph"> <p>This function returns 0 for the second input argument, since it is a valid IPV6 string; 1 for the second input argument, since it is an invalid IPVr6 string.</p> @@ -31992,7 +32048,7 @@ See <a href="#expressions">Expressions</a>.</p> </div> </div> <div class="sect2"> -<h3 id="isnull_function">7.54. ISNULL Function</h3> +<h3 id="isnull_function">7.55. ISNULL Function</h3> <div class="paragraph"> <p>The ISNULL function returns the value of the first argument if it is not null, otherwise it returns the value of the second argument. Both @@ -32024,7 +32080,7 @@ with that of <em>ck-expr</em>.</p> </ul> </div> <div class="sect3"> -<h4 id="examples_of_isnull">7.54.1. Examples of ISNULL</h4> +<h4 id="examples_of_isnull">7.55.1. Examples of ISNULL</h4> <div class="ulist"> <ul> <li> @@ -32057,7 +32113,7 @@ with that of <em>ck-expr</em>.</p> </div> </div> <div class="sect2"> -<h3 id="juliantimestamp_function">7.55. JULIANTIMESTAMP Function</h3> +<h3 id="juliantimestamp_function">7.56. JULIANTIMESTAMP Function</h3> <div class="paragraph"> <p>The JULIANTIMESTAMP function converts a datetime value into a 64-bit Julian timestamp value that represents the number of microseconds that @@ -32093,14 +32149,14 @@ specified datetime value are set to zero. See </ul> </div> <div class="sect3"> -<h4 id="considerations_for_juliantimestamp">7.55.1. Considerations for JULIANTIMESTAMP</h4> +<h4 id="considerations_for_juliantimestamp">7.56.1. Considerations for JULIANTIMESTAMP</h4> <div class="paragraph"> <p>The <em>datetime-expression</em> value must be a date or timestamp value from the beginning of year 0001 to the end of year 9999.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_juliantimestamp">7.55.2. Examples of JULIANTIMESTAMP</h4> +<h4 id="examples_of_juliantimestamp">7.56.2. Examples of JULIANTIMESTAMP</h4> <div class="paragraph"> <p>The project table consists of five columns using the data types NUMERIC, VARCHAR, DATE, TIMESTAMP, and INTERVAL.</p> @@ -32145,7 +32201,7 @@ START_DATE (EXPR) </div> </div> <div class="sect2"> -<h3 id="lastnotnull_function">7.56. LASTNOTNULL Function</h3> +<h3 id="lastnotnull_function">7.57. LASTNOTNULL Function</h3> <div class="paragraph"> <p>The LASTNOTNULL function is a sequence function that returns the last non-null value of a column in an intermediate result table ordered by a @@ -32171,7 +32227,7 @@ expression. If only null values have been returned, LASTNOTNULL returns null.</p </ul> </div> <div class="sect3"> -<h4 id="examples_of_lastnotnull">7.56.1. Examples of LASTNOTNULL</h4> +<h4 id="examples_of_lastnotnull">7.57.1. Examples of LASTNOTNULL</h4> <div class="ulist"> <ul> <li> @@ -32199,7 +32255,7 @@ lastnotnull </div> </div> <div class="sect2"> -<h3 id="lcase_function">7.57. LCASE Function</h3> +<h3 id="lcase_function">7.58. LCASE Function</h3> <div class="paragraph"> <p>The LCASE function down-shifts alphanumeric characters. For non-alphanumeric characters, LCASE returns the same character. LCASE can @@ -32234,7 +32290,7 @@ characters to down-shift. See </ul> </div> <div class="sect3"> -<h4 id="examples_of_lcase">7.57.1. Examples of LCASE</h4> +<h4 id="examples_of_lcase">7.58.1. Examples of LCASE</h4> <div class="ulist"> <ul> <li> @@ -32262,7 +32318,7 @@ Hotel Oregon HOTEL OREGON hotel oregon <div style="page-break-after: always;"></div> </div> <div class="sect3"> -<h4 id="left_function">7.57.2. LEFT Function</h4> +<h4 id="left_function">7.58.2. LEFT Function</h4> <div class="paragraph"> <p>The LEFT function returns the leftmost specified number of characters from a character expression. Every character, including multi-byte @@ -32299,7 +32355,7 @@ than or equal to 0 with a scale of zero.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_left">7.57.3. Examples of LEFT</h4> +<h4 id="examples_of_left">7.58.3. Examples of LEFT</h4> <div class="ulist"> <ul> <li> @@ -32342,7 +32398,7 @@ SECRETARY COMNET </div> </div> <div class="sect2"> -<h3 id="locate_function">7.58. LOCATE Function</h3> +<h3 id="locate_function">7.59. LOCATE Function</h3> <div class="paragraph"> <p>The LOCATE function searches for a given substring in a character string. If the substring is found, Trafodion SQL returns the character @@ -32385,7 +32441,7 @@ of zero. If substring-expression is not found in source-expression , Trafodion SQL returns 0.</p> </div> <div class="sect3"> -<h4 id="considerations_for_locate">7.58.1. Considerations for LOCATE</h4> +<h4 id="considerations_for_locate">7.59.1. Considerations for LOCATE</h4> <div class="sect4"> <h5 id="result_of_locate">Result of LOCATE</h5> <div class="ulist"> @@ -32416,7 +32472,7 @@ function) for both the <em>substring-expression</em> and the <em>source-expressi </div> </div> <div class="sect3"> -<h4 id="examples_of_locate">7.58.2. Examples of LOCATE</h4> +<h4 id="examples_of_locate">7.59.2. Examples of LOCATE</h4> <div class="ulist"> <ul> <li> @@ -32445,7 +32501,7 @@ WHERE LOCATE ('SMITH',UCASE(empname)) > 0 ;</code></pre> </div> </div> <div class="sect2"> -<h3 id="log_function">7.59. LOG Function</h3> +<h3 id="log_function">7.60. LOG Function</h3> <div class="paragraph"> <p>The LOG function returns the natural logarithm of a numeric value expression. LOG is a Trafodion SQL extension.</p> @@ -32468,7 +32524,7 @@ than zero. See <a href="#numeric_value_expressions">Numeric Value Expressions</a </ul> </div> <div class="sect3"> -<h4 id="examples_of_log">7.59.1. Examples of LOG</h4> +<h4 id="examples_of_log">7.60.1. Examples of LOG</h4> <div class="ulist"> <ul> <li> @@ -32485,7 +32541,7 @@ approximately 0.69315:</p> <div style="page-break-after: always;"></div> </div> <div class="sect3"> -<h4 id="log10_function">7.59.2. LOG10 Function</h4> +<h4 id="log10_function">7.60.2. LOG10 Function</h4> <div class="paragraph"> <p>The LOG10 function returns the base 10 logarithm of a numeric value expression.</p> @@ -32513,7 +32569,7 @@ See <a href="#numeric_value_expressions">Numeric Value Expressions</a>.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_log10">7.59.3. Examples of LOG10</h4> +<h4 id="examples_of_log10">7.60.3. Examples of LOG10</h4> <div class="ulist"> <ul> <li> @@ -32531,7 +32587,7 @@ approximately 1.3979:</p> </div> </div> <div class="sect2"> -<h3 id="lower_function">7.60. LOWER Function</h3> +<h3 id="lower_function">7.61. LOWER Function</h3> <div class="paragraph"> <p>The LOWER function down-shifts alphanumeric characters. For non-alphanumeric characters, LOWER returns the same character. LOWER can @@ -32563,7 +32619,7 @@ See <a href="#character_value_expressions">Character Value Expressions</a>.</p> </ul> </div> <div class="sect3"> -<h4 id="considerations_for_lower">7.60.1. Considerations for LOWER</h4> +<h4 id="considerations_for_lower">7.61.1. Considerations for LOWER</h4> <div class="paragraph"> <p>For a UTF8 character expression, the LOWER function down-shifts all the uppercase or title case characters in a given string to lowercase and @@ -32581,7 +32637,7 @@ and whose Unicode name includes <em>title</em>.</p> <div style="page-break-after: always;"></div> </div> <div class="sect3"> -<h4 id="examples_of_lower">7.60.2. Examples of LOWER</h4> +<h4 id="examples_of_lower">7.61.2. Examples of LOWER</h4> <div class="ulist"> <ul> <li> @@ -32609,7 +32665,7 @@ Hotel Oregon HOTEL OREGON hotel oregon <div style="page-break-after: always;"></div> </div> <div class="sect3"> -<h4 id="lpad_function">7.60.3. LPAD Function</h4> +<h4 id="lpad_function">7.61.3. LPAD Function</h4> <div class="paragraph"> <p>The LPAD function pads the left side of a string with the specified string. Every character in the string, including multi-byte characters, @@ -32651,7 +32707,7 @@ string size, the string is truncated.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_lpad">7.60.4. Examples of LPAD</h4> +<h4 id="examples_of_lpad">7.61.4. Examples of LPAD</h4> <div class="ulist"> <ul> <li> @@ -32700,7 +32756,7 @@ string size, the string is truncated.</p> </div> </div> <div class="sect2"> -<h3 id="ltrim_function">7.61. LTRIM Function</h3> +<h3 id="ltrim_function">7.62. LTRIM Function</h3> <div class="paragraph"> <p>The LTRIM function removes leading spaces from a character string. If you must remove any leading character other than space, use the TRIM @@ -32727,7 +32783,7 @@ See <a href="#character_value_expressions">Character Value Expressions</a>.</p> </ul> </div> <div class="sect3"> -<h4 id="considerations_for_ltrim">7.61.1. Considerations for LTRIM</h4> +<h4 id="considerations_for_ltrim">7.62.1. Considerations for LTRIM</h4> <div class="sect4"> <h5 id="result_of_ltrim">Result of LTRIM</h5> <div class="paragraph"> @@ -32737,7 +32793,7 @@ fixed length or maximum variable length of <em>character-expression</em>.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_ltrim">7.61.2. Examples of LTRIM</h4> +<h4 id="examples_of_ltrim">7.62.2. Examples of LTRIM</h4> <div class="ulist"> <ul> <li> @@ -32757,7 +32813,7 @@ fixed length or maximum variable length of <em>character-expression</em>.</p> </div> </div> <div class="sect2"> -<h3 id="max_function">7.62. MAX/MAXIMUM Function</h3> +<h3 id="max_function">7.63. MAX/MAXIMUM Function</h3> <div class="paragraph"> <p>MAX is an aggregate function that returns the maximum value within a set of values. MAXIMUM is the equivalent of MAX wherever the function name @@ -32797,11 +32853,11 @@ See <a href="#expressions">Expressions</a>.</p> </ul> </div> <div class="sect3"> -<h4 id="considerations_for_max">7.62.1. Considerations for MAX/MAXIMUM</h4> +<h4 id="considerations_for_max">7.63.1. Considerations for MAX/MAXIMUM</h4> </div> <div class="sect3"> -<h4 id="operands_of_the_expression">7.62.2. Operands of the Expression</h4> +<h4 id="operands_of_the_expression">7.63.2. Operands of the Expression</h4> <div class="paragraph"> <p>The expression includes columns from the rows of the SELECT result table but cannot include an aggregate function. These expressions are valid:</p> @@ -32815,7 +32871,7 @@ MAX (PARTCOST * QTY_ORDERED)</code></pre> </div> </div> <div class="sect3"> -<h4 id="examples_of_max">7.62.3. Examples of MAX/MAXIMUM</h4> +<h4 id="examples_of_max">7.63.3. Examples of MAX/MAXIMUM</h4> <div class="ulist"> <ul> <li> @@ -32838,7 +32894,7 @@ MAX (PARTCOST * QTY_ORDERED)</code></pre> </div> </div> <div class="sect2"> -<h3 id="md5_function">7.63. MD5 Function</h3> +<h3 id="md5_function">7.64. MD5 Function</h3> <div class="paragraph"> <p>Calculates an MD5 128-bit checksum for the string. The value is returned as a string of 32 hexadecimal digits, or NULL if the argument was NULL.</p> @@ -32862,7 +32918,7 @@ See <a href="#expressions">Expressions</a>.</p> </ul> </div> <div class="sect3"> -<h4 id="examples_of_md5">7.63.1. Examples of MD5</h4> +<h4 id="examples_of_md5">7.64.1. Examples of MD5</h4> <div class="paragraph"> <p>The return value is a nonbinary string in the connection character set.</p> </div> @@ -32879,7 +32935,7 @@ See <a href="#expressions">Expressions</a>.</p> </div> </div> <div class="sect2"> -<h3 id="min_function">7.64. MIN Function</h3> +<h3 id="min_function">7.65. MIN Function</h3> <div class="paragraph"> <p>MIN is an aggregate function that returns the minimum value within a set of values. The data type of the result is the same as the data type of @@ -32917,7 +32973,7 @@ See <a href="#expressions">Expressions</a>.</p> </ul> </div> <div class="sect3"> -<h4 id="considerations_for_min">7.64.1. Considerations for MIN</h4> +<h4 id="considerations_for_min">7.65.1. Considerations for MIN</h4> <div class="sect4"> <h5 id="operands_of_the_expression_3">Operands of the Expression</h5> <div class="paragraph"> @@ -32936,7 +32992,7 @@ MIN (PARTCOST * QTY_ORDERED)</code></pre> </div> </div> <div class="sect3"> -<h4 id="examples_of_min">7.64.2. Examples of MIN</h4> +<h4 id="examples_of_min">7.65.2. Examples of MIN</h4> <div class="ulist"> <ul> <li> @@ -32959,7 +33015,7 @@ MIN (PARTCOST * QTY_ORDERED)</code></pre> </div> </div> <div class="sect2"> -<h3 id="minute_function">7.65. MINUTE Function</h3> +<h3 id="minute_function">7.66. MINUTE Function</h3> <div class="paragraph"> <p>The MINUTE function converts a TIME or TIMESTAMP expression into an INTEGER value, in the range 0 through 59, that represents the @@ -32985,7 +33041,7 @@ TIMESTAMP. See <a href="#datetime_value_expressions">Datetime Value Expressions< </ul> </div> <div class="sect3"> -<h4 id="examples_of_minute">7.65.1. Examples of minute</h4> +<h4 id="examples_of_minute">7.66.1. Examples of minute</h4> <div class="ulist"> <ul> <li> @@ -33009,7 +33065,7 @@ Start/Date Time/Shipped (EXPR) </div> </div> <div class="sect2"> -<h3 id="mod_function">7.66. MOD Function</h3> +<h3 id="mod_function">7.67. MOD Function</h3> <div class="paragraph"> <p>The MOD function returns the remainder (modulus) of an integer value expression divided by an integer value expression.</p> @@ -33044,7 +33100,7 @@ See <a href="#numeric_value_expressions">Numeric Value Expressions</a>.</p> </ul> </div> <div class="sect3"> -<h4 id="examples_of_mod">7.66.1. Examples of MOD</h4> +<h4 id="examples_of_mod">7.67.1. Examples of MOD</h4> <div class="ulist"> <ul> <li> @@ -33061,7 +33117,7 @@ See <a href="#numeric_value_expressions">Numeric Value Expressions</a>.</p> </div> </div> <div class="sect2"> -<h3 id="month_function">7.67. MONTH Function</h3> +<h3 id="month_function">7.68. MONTH Function</h3> <div class="paragraph"> <p>The MONTH function converts a DATE or TIMESTAMP expression into an INTEGER value in the range 1 through 12 that represents the @@ -33087,7 +33143,7 @@ TIMESTAMP. See <a href="#datetime_value_expressions">Datetime Value Expressions< </ul> </div> <div class="sect3"> -<h4 id="examples_of_month">7.67.1. Examples of MONTH</h4> +<h4 id="examples_of_month">7.68.1. Examples of MONTH</h4> <div class="ulist"> <ul> <li> @@ -33110,7 +33166,7 @@ Start/Date Time/Shipped (EXPR) </div> </div> <div class="sect2"> -<h3 id="monthname_function">7.68. MONTHNAME Function</h3> +<h3 id="monthname_function">7.69. MONTHNAME Function</h3> <div class="paragraph"> <p>The MONTHNAME function converts a DATE or TIMESTAMP expression into a character literal that is the name of the month of the year (January, @@ -33136,13 +33192,13 @@ TIMESTAMP. See <a href="#datetime_value_expressions">Datetime Value Expressions< </ul> </div> <div class="sect3"> -<h4 id="considerations_for_monthname">7.68.1. Considerations for MONTHNAME</h4> +<h4 id="considerations_for_monthname">7.69.1. Considerations for MONTHNAME</h4> <div class="paragraph"> <p>The MONTHNAME function returns the name of the month in ISO8859-1.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_monthname">7.68.2. Examples of MONTHNAME</h4> +<h4 id="examples_of_monthname">7.69.2. Examples of MONTHNAME</h4> <div class="ulist"> <ul> <li> @@ -33166,7 +33222,7 @@ Start/Date Time/Shipped (EXPR) </div> </div> <div class="sect2"> -<h3 id="movingavg_function">7.69. MOVINGAVG Function</h3> +<h3 id="movingavg_function">7.70. MOVINGAVG Function</h3> <div class="paragraph"> <p>The MOVINGAVG function is a sequence function that returns the average of non-null values of a column in the current window of an intermediate @@ -33243,7 +33299,7 @@ the result table, negative, or NULL.</p> </div> <div style="page-break-after: always;"></div> <div class="sect3"> -<h4 id="examples_of_movingavg">7.69.1. Examples of MOVINGAVG</h4> +<h4 id="examples_of_movingavg">7.70.1. Examples of MOVINGAVG</h4> <div class="ulist"> <ul> <li> @@ -33281,7 +33337,7 @@ MOVINGAVG3 </div> </div> <div class="sect2"> -<h3 id="movingcount_function">7.70. MOVINGCOUNT Function</h3> +<h3 id="movingcount_function">7.71. MOVINGCOUNT Function</h3> <div class="paragraph"> <p>The MOVINGCOUNT function is a sequence function that returns the number of non-null values of a column in the current window of an intermediate @@ -33358,7 +33414,7 @@ the result table, negative, or NULL.</p> </div> <div style="page-break-after: always;"></div> <div class="sect3"> -<h4 id="considerations_for_movingcount">7.70.1. Considerations for MOVINGCOUNT</h4> +<h4 id="considerations_for_movingcount">7.71.1. Considerations for MOVINGCOUNT</h4> <div class="paragraph"> <p>The MOVINGCOUNT sequence function is defined differently from the COUNT aggregate function. If you specify DISTINCT for the COUNT aggregate @@ -33368,7 +33424,7 @@ values are counted.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_movingcount">7.70.2. Examples of MOVINGCOUNT</h4> +<h4 id="examples_of_movingcount">7.71.2. Examples of MOVINGCOUNT</h4> <div class="ulist"> <ul> <li> @@ -33397,7 +33453,7 @@ MOVINGCOUNT3 </div> </div> <div class="sect2"> -<h3 id="movingmax_function">7.71. MOVINGMAX Function</h3> +<h3 id="movingmax_function">7.72. MOVINGMAX Function</h3> <div class="paragraph"> <p>The MOVINGMAX function is a sequence function that returns the maximum of non-null values of a column in the current window of an intermediate @@ -33474,7 +33530,7 @@ the result table, negative, or NULL.</p> </div> <div style="page-break-after: always;"></div> <div class="sect3"> -<h4 id="examples_of_movingmax">7.71.1. Examples of MOVINGMAX</h4> +<h4 id="examples_of_movingmax">7.72.1. Examples of MOVINGMAX</h4> <div class="ulist"> <ul> <li> @@ -33503,7 +33559,7 @@ MOVINGMAX3 </div> </div> <div class="sect2"> -<h3 id="movingmin_function">7.72. MOVINGMIN Function</h3> +<h3 id="movingmin_function">7.73. MOVINGMIN Function</h3> <div class="paragraph"> <p>The MOVINGMIN function is a sequence function that returns the minimum of non-null values of a column in the current window of an intermediate @@ -33580,7 +33636,7 @@ the result table, negative, or NULL.</p> </div> <div style="page-break-after: always;"></div> <div class="sect3"> -<h4 id="examples_of_movingmin">7.72.1. Examples of MOVINGMIN</h4> +<h4 id="examples_of_movingmin">7.73.1. Examples of MOVINGMIN</h4> <div class="ulist"> <ul> <li> @@ -33609,7 +33665,7 @@ MOVINGMIN3 </div> </div> <div class="sect2"> -<h3 id="movingstddev_function">7.73. MOVINGSTDDEV Function</h3> +<h3 id="movingstddev_function">7.74. MOVINGSTDDEV Function</h3> <div class="paragraph"> <p>The MOVINGSTDDEV function is a sequence function that returns the standard deviation of non-null values of a column in the current window @@ -33686,7 +33742,7 @@ the result table, negative, or NULL.</p> </div> <div style="page-break-after: always;"></div> <div class="sect3"> -<h4 id="examples_of_movingstddev">7.73.1. Examples of MOVINGSTDDEV</h4> +<h4 id="examples_of_movingstddev">7.74.1. Examples of MOVINGSTDDEV</h4> <div class="ulist"> <ul> <li> @@ -33734,7 +33790,7 @@ FROM mining.seqfcn SEQUENCE BY ts; </div> </div> <div class="sect2"> -<h3 id="movingsum_function">7.74. MOVINGSUM Function</h3> +<h3 id="movingsum_function">7.75. MOVINGSUM Function</h3> <div class="paragraph"> <p>The MOVINGSUM function is a sequence function that returns the sum of non-null values of a column in the current window of an intermediate @@ -33811,7 +33867,7 @@ the result table, negative, or NULL.</p> </div> <div style="page-break-after: always;"></div> <div class="sect3"> -<h4 id="examples_of_movingsum">7.74.1. Examples of MOVINGSUM</h4> +<h4 id="examples_of_movingsum">7.75.1. Examples of MOVINGSUM</h4> <div class="ulist"> <ul> <li> @@ -33840,7 +33896,7 @@ MOVINGSUM3 </div> </div> <div class="sect2"> -<h3 id="movingvariance_function">7.75. MOVINGVARIANCE Function</h3> +<h3 id="movingvariance_function">7.76. MOVINGVARIANCE Function</h3> <div class="paragraph"> <p>The MOVINGVARIANCE function is a sequence function that returns the variance of non-null values of a column in the current window of an @@ -33917,7 +33973,7 @@ the result table, negative, or NULL.</p> </div> <div style="page-break-after: always;"></div> <div class="sect3"> -<h4 id="examples_of_movingvariance">7.75.1. Examples of MOVINGVARIANCE</h4> +<h4 id="examples_of_movingvariance">7.76.1. Examples of MOVINGVARIANCE</h4> <div class="ulist"> <ul> <li> @@ -33964,7 +34020,7 @@ FROM mining.seqfcn SEQUENCE BY ts; <div style="page-break-after: always;"></div> </div> <div class="sect3"> -<h4 id="nullif_function">7.75.2. NULLIF Function</h4> +<h4 id="nullif_function">7.76.2. NULLIF Function</h4> <div class="paragraph"> <p>The NULLIF function compares the value of two expressions. Both expressions must be of comparable types. The return value is NULL when @@ -34009,7 +34065,7 @@ the value of the first argument when the two expressions are not equal.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_nullif">7.75.3. Examples of NULLIF</h4> +<h4 id="examples_of_nullif">7.76.3. Examples of NULLIF</h4> <div class="ulist"> <ul> <li> @@ -34027,7 +34083,7 @@ value is the value of the first argument when that value is not 7.</p> </div> </div> <div class="sect2"> -<h3 id="nullifzero_function">7.76. NULLIFZERO Function</h3> +<h3 id="nullifzero_function">7.77. NULLIFZERO Function</h3> <div class="paragraph"> <p>The NULLIFZERO function returns the value of the expression if that value is not zero. It returns NULL if the value of the expression is @@ -34050,7 +34106,7 @@ zero.</p> </div> <div style="page-break-after: always;"></div> <div class="sect3"> -<h4 id="examples_of_nullifzero">7.76.1. Examples of NULLIFZERO</h4> +<h4 id="examples_of_nullifzero">7.77.1. Examples of NULLIFZERO</h4> <div class="ulist"> <ul> <li> @@ -34085,7 +34141,7 @@ where the column’s value is zero.</p> </div> </div> <div class="sect2"> -<h3 id="nvl_function">7.77. NVL Function</h3> +<h3 id="nvl_function">7.78. NVL Function</h3> <div class="paragraph"> <p>The NVL function determines if the selected column has a null value and then returns the new-operand value; otherwise the operand value is @@ -34122,7 +34178,7 @@ is not a null value, NVL returns <em>operand</em>.</p> Trafodion SQL string functions, math functions, or constant values.</p> </div> <div class="sect3"> -<h4 id="examples_of_nvl">7.77.1. Examples of NVL</h4> +<h4 id="examples_of_nvl">7.78.1. Examples of NVL</h4> <div class="ulist"> <ul> <li> @@ -34186,7 +34242,7 @@ A1 </div> </div> <div class="sect2"> -<h3 id="octet_length_function">7.78. OCTET_LENGTH Function</h3> +<h3 id="octet_length_function">7.79. OCTET_LENGTH Function</h3> <div class="paragraph"> <p>The OCTET_LENGTH function returns the length of a character string in bytes.</p> @@ -34211,7 +34267,7 @@ See <a href="#character_value_expressions">Character Value Expressions</a>.</p> </ul> </div> <div class="sect3"> -<h4 id="considerations_for_octet_length">7.78.1. Considerations for OCTET_LENGTH</h4> +<h4 id="considerations_for_octet_length">7.79.1. Considerations for OCTET_LENGTH</h4> <div class="sect4"> <h5 id="char_and_varchar_operands_1">CHAR and VARCHAR Operands</h5> <div class="paragraph"> @@ -34250,7 +34306,7 @@ function returns the value 12. Otherwise, the function returns 6:</p> </div> </div> <div class="sect3"> -<h4 id="offset_function">7.78.2. OFFSET Function</h4> +<h4 id="offset_function">7.79.2. OFFSET Function</h4> <div class="paragraph"> <p>The OFFSET function is a sequence function that retrieves columns from previous rows of an intermediate result table ordered by a SEQUENCE BY @@ -34295,7 +34351,7 @@ INTEGER that specifies the maximum number of rows of the offset.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_offset">7.78.3. Examples of OFFSET</h4> +<h4 id="examples_of_offset">7.79.3. Examples of OFFSET</h4> <div class="ulist"> <ul> <li> @@ -34327,7 +34383,7 @@ current row does not fall within the result table.</p> </div> </div> <div class="sect2"> -<h3 id="pi_function">7.79. PI Function</h3> +<h3 id="pi_function">7.80. PI Function</h3> <div class="paragraph"> <p>The PI function returns the constant value of pi as a floating-point value.</p> @@ -34341,7 +34397,7 @@ value.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_pi">7.79.1. Examples of PI</h4> +<h4 id="examples_of_pi">7.80.1. Examples of PI</h4> <div class="ulist"> <ul> <li> @@ -34358,7 +34414,7 @@ value.</p> </div> </div> <div class="sect2"> -<h3 id="position_function">7.80. POSITION Function</h3> +<h3 id="position_function">7.81. POSITION Function</h3> <div class="paragraph"> <p>The POSITION function searches for a given substring in a character string. If the substring is found, Trafodion SQL returns the character @@ -34398,7 +34454,7 @@ of zero. If <em>substring-expression</em> is not found in <em>source-expression< Trafodion SQL returns zero.</p> </div> <div class="sect3"> -<h4 id="considerations_for_position">7.80.1. Considerations for POSITION</h4> +<h4 id="considerations_for_position">7.81.1. Considerations for POSITION</h4> <div class="sect4"> <h5 id="result_of_position">Result of POSITION</h5> <div class="paragraph"> @@ -34421,7 +34477,7 @@ function) for both the <em>substring-expression</em> and the <em>source-expressi </div> </div> <div class="sect3"> -<h4 id="examples_of_position">7.80.2. Examples of POSITION</h4> +<h4 id="examples_of_position">7.81.2. Examples of POSITION</h4> <div class="ulist"> <ul> <li> @@ -34451,7 +34507,7 @@ WHERE POSITION ('SMITH' IN UPSHIFT(empname)) > 0 ;</code></pre> </div> </div> <div class="sect2"> -<h3 id="power_function">7.81. POWER Function</h3> +<h3 id="power_function">7.82. POWER Function</h3> <div class="paragraph"> <p>The POWER function returns the value of a numeric value expression raised to the power of an integer value expression. You can also use the @@ -34484,7 +34540,7 @@ exponent must be a value with an exact numeric data type and a scale of zero.</p </ul> </div> <div class="sect3"> -<h4 id="examples_of_power">7.81.1. Examples of POWER</h4> +<h4 id="examples_of_power">7.82.1. Examples of POWER</h4> <div class="ulist"> <ul> <li> @@ -34510,7 +34566,7 @@ the inverse of the function SQRT:</p> </div> </div> <div class="sect2"> -<h3 id="quarter_function">7.82. QUARTER Function</h3> +<h3 id="quarter_function">7.83. QUARTER Function</h3> <div class="paragraph"> <p>The QUARTER function converts a DATE or TIMESTAMP expression into an INTEGER value in the range 1 through 4 that represents the corresponding @@ -34537,7 +34593,7 @@ TIMESTAMP. See <a href="#datetime_value_expressions">Datetime Value Expressions< </ul> </div> <div class="sect3"> -<h4 id="examples_of_quarter">7.82.1. Examples of QUARTER</h4> +<h4 id="examples_of_quarter">7.83.1. Examples of QUARTER</h4> <div class="ulist"> <ul> <li> @@ -34561,7 +34617,7 @@ Start/Date Time/Shipped (EXPR) </div> </div> <div class="sect2"> -<h3 id="radians_function">7.83. RADIANS Function</h3> +<h3 id="radians_function">7.84. RADIANS Function</h3> <div class="paragraph"> <p>The RADIANS function converts a numeric value expression (expressed in degrees) to the number of radians.</p> @@ -34587,7 +34643,7 @@ See <a href="#numeric_value_expressions">Numeric Value Expressions</a>.</p> </ul> </div> <div class="sect3"> -<h4 id="examples_of_radians">7.83.1. Examples of RADIANS</h4> +<h4 id="examples_of_radians">7.84.1. Examples of RADIANS</h4> <div class="ulist"> <ul> <li> @@ -34613,7 +34669,7 @@ the function RADIANS.</p> </div> </div> <div class="sect2"> -<h3 id="runningrank_function">7.84. RANK/RUNNINGRANK Function</h3> +<h3 id="runningrank_function">7.85. RANK/RUNNINGRANK Function</h3> <div class="paragraph"> <p>The RANK/RUNNINGRANK function is a sequence function that returns the rank of the given value of an intermediate result table ordered by a @@ -34658,7 +34714,7 @@ rank. The value of RANK advances to the relative position of the row in the intermediate result when the value changes.</p> </div> <div class="sect3"> -<h4 id="considerations_for_runningrank">7.84.1. Considerations for RANK/RUNNINGRANK</h4> +<h4 id="considerations_for_runningrank">7.85.1. Considerations for RANK/RUNNINGRANK</h4> <div class="sect4"> <h5 id="sequence_order_dependency">Sequence Order Dependency</h5> <div class="paragraph"> @@ -34681,7 +34737,7 @@ expression.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_runningrank">7.84.2. Examples of RANK/RUNNINGRANK</h4> +<h4 id="examples_of_runningrank">7.85.2. Examples of RANK/RUNNINGRANK</h4> <div class="ulist"> <ul> <li> @@ -34860,7 +34916,7 @@ i2 rank </div> </div> <div class="sect2"> -<h3 id="repeat_function">7.85. REPEAT Function</h3> +<h3 id="repeat_function">7.86. REPEAT Function</h3> <div class="paragraph"> <p>The REPEAT function returns a character string composed of the evaluation of a character expression repeated a specified number of @@ -34896,7 +34952,7 @@ be repeated. The number count must be a value greater than or equal to zero of exact numeric data type and with a scale of zero.</p> </div> <div class="sect3"> -<h4 id="examples_of_repeat">7.85.1. Examples of REPEAT</h4> +<h4 id="examples_of_repeat">7.86.1. Examples of REPEAT</h4> <div class="ulist"> <ul> <li> @@ -34915,7 +34971,7 @@ Never,Never,Never,Never,Never,</code></pre> </div> </div> <div class="sect2"> -<h3 id="replace_function">7.86. REPLACE Function</h3> +<h3 id="replace_function">7.87. REPLACE Function</h3> <div class="paragraph"> <p>The REPLACE function returns a character string where all occurrences of a specified character string in the original string are replaced with @@ -34944,7 +35000,7 @@ See <a href="#character_value_expressions">Character Value Expressions</a>.</p> </ul> </div> <div class="sect3"> -<h4 id="examples_of_replace">7.86.1. Examples of REPLACE</h4> +<h4 id="examples_of_replace">7.87.1. Examples of REPLACE</h4> <div class="ulist"> <ul> <li> @@ -34987,7 +35043,7 @@ SYSTEM ANAL TDMNET </div> </div> <div class="sect2"> -<h3 id="right_function">7.87. RIGHT Function</h3> +<h3 id="right_function">7.88. RIGHT Function</h3> <div class="paragraph"> <p>The RIGHT function returns the rightmost specified number of characters from a character expression. Every character, including multi-byte @@ -35023,7 +35079,7 @@ of zero.</p> </ul> </div> <div class="sect3"> -<h4 id="examples_of_right">7.87.1. Examples of RIGHT</h4> +<h4 id="examples_of_right">7.88.1. Examples of RIGHT</h4> <div class="ulist"> <ul> <li> @@ -35052,7 +35108,7 @@ SET jobdesc = RIGHT (jobdesc, 12);</code></pre> </div> </div> <div class="sect2"> -<h3 id="round_function">7.88. ROUND Function</h3> +<h3 id="round_function">7.89. ROUND Function</h3> <div class="paragraph"> <p>The ROUND function returns the value of <em>numeric_expr</em> rounded to <em>num</em> places to the right of the decimal point.</p> @@ -35093,7 +35149,7 @@ value <em>numeric_expr</em> is rounded toward the nearest even number.</p> </div> <div style="page-break-after: always;"></div> <div class="sect3"> -<h4 id="examples_of_round">7.88.1. Examples of ROUND</h4> +<h4 id="examples_of_round">7.89.1. Examples of ROUND</h4> <div class="ulist"> <ul> <li> @@ -35166,7 +35222,7 @@ value <em>numeric_expr</em> is rounded toward the nearest even number.</p> </div> </div> <div class="sect2"> -<h3 id="rows_since_function">7.89. ROWS SINCE Function</h3> +<h3 id="rows_since_function">7.90. ROWS SINCE Function</h3> <div class="paragraph"> <p>The ROWS SINCE function is a sequence function that returns the number of rows counted since the specified condition was last true in the @@ -35214,7 +35270,7 @@ returns null.</p> </ul> </div> <div class="sect3"> -<h4 id="considerations_for_rows_since">7.89.1. Considerations for ROWS SINCE</h4> +<h4 id="considerations_for_rows_since">7.90.1. Considerations for ROWS SINCE</h4> <div class="sect4"> <h5 id="counting_the_rows">Counting the Rows</h5> <div class="paragraph"> @@ -35232,7 +35288,7 @@ Trafodion SQL then goes to the next row as the new current row.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_rows_since">7.89.2. Examples of ROWS SINCE</h4> +<h4 id="examples_of_rows_since">7.90.2. Examples of ROWS SINCE</h4> <div class="ulist"> <ul> <li> @@ -35279,7 +35335,7 @@ FROM mining.seqfcn SEQUENCE BY ts; </div> </div> <div class="sect2"> -<h3 id="rows_since_changed_function">7.90. ROWS SINCE CHANGED Function</h3> +<h3 id="rows_since_changed_function">7.91. ROWS SINCE CHANGED Function</h3> <div class="paragraph"> <p>The ROWS SINCE CHANGED function is a sequence function that returns the number of rows counted since the specified set of values last changed in @@ -35308,7 +35364,7 @@ values of <em>column-expression-list</em> changed.</p> </ul> </div> <div class="sect3"> -<h4 id="considerations_for_rows_since_changed">7.90.1. Considerations for ROWS SINCE CHANGED</h4> +<h4 id="considerations_for_rows_since_changed">7.91.1. Considerations for ROWS SINCE CHANGED</h4> <div class="sect4"> <h5 id="counting_the_rows">Counting the Rows</h5> <div class="paragraph"> @@ -35322,7 +35378,7 @@ than the previous row, the count is 1.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_rows_since_changed">7.90.2. Examples of ROWS SINCE CHANGED</h4> +<h4 id="examples_of_rows_since_changed">7.91.2. Examples of ROWS SINCE CHANGED</h4> <div class="ulist"> <ul> <li> @@ -35349,7 +35405,7 @@ FROM mining.seqfcn SEQUENCE BY ts;</code></pre> </div> </div> <div class="sect2"> -<h3 id="rpad_function">7.91. RPAD Function</h3> +<h3 id="rpad_function">7.92. RPAD Function</h3> <div class="paragraph"> <p>The RPAD function pads the right side of a string with the specified string. Every character in the string, including multi-byte characters, @@ -35391,7 +35447,7 @@ string size, the string is truncated.</p> </div> <div style="page-break-after: always;"></div> <div class="sect3"> -<h4 id="examples_of_rpad_function">7.91.1. Examples of RPAD Function</h4> +<h4 id="examples_of_rpad_function">7.92.1. Examples of RPAD Function</h4> <div class="ulist"> <ul> <li> @@ -35448,7 +35504,7 @@ string size, the string is truncated.</p> </div> </div> <div class="sect2"> -<h3 id="rtrim_function">7.92. RTRIM Function</h3> +<h3 id="rtrim_function">7.93. RTRIM Function</h3> <div class="paragraph"> <p>The RTRIM function removes trailing spaces from a character string. If you must remove any leading character other than space, use the TRIM @@ -35478,7 +35534,7 @@ to trim trailing spaces.</p> </ul> </div> <div class="sect3"> -<h4 id="considerations_for_rtrim">7.92.1. Considerations for RTRIM</h4> +<h4 id="considerations_for_rtrim">7.93.1. Considerations for RTRIM</h4> <div class="sect4"> <h5 id="result_of_rtrim">Result of RTRIM</h5> <div class="paragraph"> @@ -35488,7 +35544,7 @@ fixed length or maximum variable length of <em>character-expression</em>.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_rtrim">7.92.2. Examples of RTRIM</h4> +<h4 id="examples_of_rtrim">7.93.2. Examples of RTRIM</h4> <div class="ulist"> <ul> <li> @@ -35508,7 +35564,7 @@ fixed length or maximum variable length of <em>character-expression</em>.</p> </div> </div> <div class="sect2"> -<h3 id="runningavg_function">7.93. RUNNINGAVG Function</h3> +<h3 id="runningavg_function">7.94. RUNNINGAVG Function</h3> <div class="paragraph"> <p>The RUNNINGAVG function is a sequence function that returns the average of non-null values of a column up to and including the current row of an @@ -35539,7 +35595,7 @@ up to and including the current row.</p> </ul> </div> <div class="sect3"> -<h4 id="considerations_for_runningavg">7.93.1. Considerations for RUNNINGAVG</h4> +<h4 id="considerations_for_runningavg">7.94.1. Considerations for RUNNINGAVG</h4> <div class="sect4"> <h5 id="equivalent_result">Equivalent Result</h5> <div class="paragraph"> @@ -35553,7 +35609,7 @@ up to and including the current row.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_runningavg">7.93.2. Examples of RUNNINGAVG</h4> +<h4 id="examples_of_runningavg">7.94.2. Examples of RUNNINGAVG</h4> <div class="ulist"> <ul> <li> @@ -35582,7 +35638,7 @@ avg_i1 </div> </div> <div class="sect2"> -<h3 id="runningcount_function">7.94. RUNNINGCOUNT Function</h3> +<h3 id="runningcount_function">7.95. RUNNINGCOUNT Function</h3> <div class="paragraph"> <p>The RUNNINGCOUNT function is a sequence function that returns the number of rows up to and including the current row of an intermediate result @@ -35618,7 +35674,7 @@ intermediate result table up to and including the current row.</p> </ul> </div> <div class="sect3"> -<h4 id="considerations_for_runningcount">7.94.1. Considerations for RUNNINGCOUNT</h4> +<h4 id="considerations_for_runningcount">7.95.1. Considerations for RUNNINGCOUNT</h4> <div class="sect4"> <h5 id="no_distinct_clause">No DISTINCT Clause</h5> <div class="paragraph"> @@ -35632,7 +35688,7 @@ duplicate values are counted.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_runningcount">7.94.2. Examples of RUNNINGCOUNT</h4> +<h4 id="examples_of_runningcount">7.95.2. Examples of RUNNINGCOUNT</h4> <div class="ulist"> <ul> <li> @@ -35661,7 +35717,7 @@ count_i1 </div> </div> <div class="sect2"> -<h3 id="runningmax_function">7.95. RUNNINGMAX Function</h3> +<h3 id="runningmax_function">7.96. RUNNINGMAX Function</h3> <div class="paragraph"> <p>The RUNNINGMAX function is a sequence function that returns the maximum of values of a column up to and including the current row of an @@ -35692,7 +35748,7 @@ and including the current row.</p> </ul> </div> <div class="sect3"> -<h4 id="examples_of_runningmax">7.95.1. Examples of RUNNINGMAX</h4> +<h4 id="examples_of_runningmax">7.96.1. Examples of RUNNINGMAX</h4> <div class="ulist"> <ul> <li> @@ -35720,7 +35776,7 @@ max_i1 </div> </div> <div class="sect2"> -<h3 id="runningmin_function">7.96. RUNNINGMIN Function</h3> +<h3 id="runningmin_function">7.97. RUNNINGMIN Function</h3> <div class="paragraph"> <p>The RUNNINGMIN function is a sequence function that returns the minimum of values of a column up to and including the current row of an @@ -35751,7 +35807,7 @@ and including the current row.</p> </ul> </div> <div class="sect3"> -<h4 id="examples_of_runningmin">7.96.1. Examples of RUNNINGMIN</h4> +<h4 id="examples_of_runningmin">7.97.1. Examples of RUNNINGMIN</h4> <div class="ulist"> <ul> <li> @@ -35778,7 +35834,7 @@ min_i1 <div style="page-break-after: always;"></div> </div> <div class="sect3"> -<h4 id="runningstddev_function">7.96.2. RUNNINGSTDDEV Function</h4> +<h4 id="runningstddev_function">7.97.2. RUNNINGSTDDEV Function</h4> <div class="paragraph"> <p>The RUNNINGSTDDEV function is a sequence function that returns the standard deviation of non-null values of a column up to and including the @@ -35811,7 +35867,7 @@ expression.</p> </div> </div> <div class="sect3"> -<h4 id="considerations_for_runningstddev">7.96.3. Considerations for RUNNINGSTDDEV</h4> +<h4 id="considerations_for_runningstddev">7.97.3. Considerations for RUNNINGSTDDEV</h4> <div class="sect4"> <h5 id="equivalent_result">Equivalent Result</h5> <div class="paragraph"> @@ -35826,7 +35882,7 @@ expression.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_runningstddev">7.96.4. Examples of RUNNINGSTDDEV</h4> +<h4 id="examples_of_runningstddev">7.97.4. Examples of RUNNINGSTDDEV</h4> <div class="ulist"> <ul> <li> @@ -35874,7 +35930,7 @@ FROM mining.seqfcn SEQUENCE BY ts; </div> </div> <div class="sect2"> -<h3 id="runningsum_function">7.97. RUNNINGSUM Function</h3> +<h3 id="runningsum_function">7.98. RUNNINGSUM Function</h3> <div class="paragraph"> <p>The RUNNINGSUM function is a sequence function that returns the sum of non-null values of a column up to and including the current row of an @@ -35905,7 +35961,7 @@ to and including the current row.</p> </ul> </div> <div class="sect3"> -<h4 id="examples_of_runningsum">7.97.1. Examples of RUNNINGSUM</h4> +<h4 id="examples_of_runningsum">7.98.1. Examples of RUNNINGSUM</h4> <div class="ulist"> <ul> <li> @@ -35934,7 +35990,7 @@ sum_i1 </div> </div> <div class="sect2"> -<h3 id="runningvariance_function">7.98. RUNNINGVARIANCE Function</h3> +<h3 id="runningvariance_function">7.99. RUNNINGVARIANCE Function</h3> <div class="paragraph"> <p>The RUNNINGVARIANCE function is a sequence function that returns the variance of non-null values of a column up to and including the current @@ -35965,7 +36021,7 @@ expression.</p> </ul> </div> <div class="sect3"> -<h4 id="examples_of_runningvariance">7.98.1. Examples of RUNNINGVARIANCE</h4> +<h4 id="examples_of_runningvariance">7.99.1. Examples of RUNNINGVARIANCE</h4> <div class="ulist"> <ul> <li> @@ -36018,7 +36074,7 @@ FROM mining.seqfcn SEQUENCE BY ts; </div> </div> <div class="sect2"> -<h3 id="second_function">7.99. SECOND Function</h3> +<h3 id="second_function">7.100. SECOND Function</h3> <div class="paragraph"> <p>The SECOND function converts a TIME or TIMESTAMP expression into an INTEGER value in the range 0 through 59 that represents the @@ -36044,7 +36100,7 @@ TIMESTAMP. See <a href="#datetime_value_expressions">Datetime Value Expressions< </ul> </div> <div class="sect3"> -<h4 id="examples_of_second">7.99.1. Examples of SECOND</h4> +<h4 id="examples_of_second">7.100.1. Examples of SECOND</h4> <div class="ulist"> <ul> <li> @@ -36068,14 +36124,14 @@ Start/Date Time/Shipped (EXPR) </div> </div> <div class="sect2"> -<h3 id="sha_function">7.100. SHA Function</h3> +<h3 id="sha_function">7.101. SHA Function</h3> <div class="paragraph"> <p>Calculates an SHA-1 160-bit checksum for the string, as described in RFC 3174 (Secure Hash Algorithm). The value is returned as a string of 40 hexadecimal digits, or NULL if the argument was NULL.</p> </div> <div class="sect3"> -<h4 id="examples_of_sha">7.100.1. examples of SHA</h4> +<h4 id="examples_of_sha">7.101.1. examples of SHA</h4> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">>>SELECT SHA1('abc') from dual; @@ -36089,7 +36145,7 @@ RFC 3174 (Secure Hash Algorithm). The value is returned as a string of </div> </div> <div class="sect2"> -<h3 id="sha2_function">7.101. SHA2 Function</h3> +<h3 id="sha2_function">7.102. SHA2 Function</h3> <div class="paragraph"> <p>Calculates the SHA-2 family of hash functions (SHA-224, SHA-256, SHA-384, and SHA-512). The first argument is the cleartext string to be hashed. @@ -36101,7 +36157,7 @@ the desired number of bits. See the notes at the beginning of this section about storing hash values efficiently.</p> </div> <div class="sect3"> -<h4 id="examples_of_sha2">7.101.1. examples of SHA2</h4> +<h4 id="examples_of_sha2">7.102.1. examples of SHA2</h4> <div class="listingblock"> <div class="content"> <pre class="CodeRay highlight"><code data-lang="text">>>SELECT SHA2('abc', 224) from dual; @@ -36115,7 +36171,7 @@ about storing hash values efficiently.</p> </div> </div> <div class="sect2"> -<h3 id="sign_function">7.102. SIGN Function</h3> +<h3 id="sign_function">7.103. SIGN Function</h3> <div class="paragraph"> <p>The SIGN function returns an indicator of the sign of a numeric value expression. If the value is less than zero, the function returns -1 as @@ -36143,7 +36199,7 @@ See <a href="#numeric_value_expressions">Numeric Value Expressions</a>.</p> </ul> </div> <div class="sect3"> -<h4 id="examples_of_sign">7.102.1. Examples of SIGN</h4> +<h4 id="examples_of_sign">7.103.1. Examples of SIGN</h4> <div class="ulist"> <ul> <li> @@ -36176,7 +36232,7 @@ See <a href="#numeric_value_expressions">Numeric Value Expressions</a>.</p> </div> </div> <div class="sect2"> -<h3 id="sin_function">7.103. SIN Function</h3> +<h3 id="sin_function">7.104. SIN Function</h3> <div class="paragraph"> <p>The SIN function returns the SINE of a numeric value expression, where the expression is an angle expressed in radians.</p> @@ -36202,7 +36258,7 @@ See <a href="#numeric_value_expressions">Numeric Value Expressions</a>.</p> </ul> </div> <div class="sect3"> -<h4 id="examples_of_sin">7.103.1. Examples of SIN</h4> +<h4 id="examples_of_sin">7.104.1. Examples of SIN</h4> <div class="ulist"> <ul> <li> @@ -36220,7 +36276,7 @@ approximately 0.3420, the sine of 0.3491 (which is 20 degrees):</p> </div> </div> <div class="sect2"> -<h3 id="sinh_function">7.104. SINH Function</h3> +<h3 id="sinh_function">7.105. SINH Function</h3> <div class="paragraph"> <p>The SINH function returns the hyperbolic sine of a numeric value expression, where the expression is an angle expressed in radians.</p> @@ -36246,7 +36302,7 @@ See <a href="#numeric_value_expressions">Numeric Value Expressions</a>.</p> </ul> </div> <div class="sect3"> -<h4 id="examples_of_sinh">7.104.1. Examples of SINH</h4> +<h4 id="examples_of_sinh">7.105.1. Examples of SINH</h4> <div class="ulist"> <ul> <li> @@ -36263,7 +36319,7 @@ approximately 1.6019, the hyperbolic sine of 1.25:</p> <div style="page-break-after: always;"></div> </div> <div class="sect3"> -<h4 id="space_function">7.104.2. SPACE Function</h4> +<h4 id="space_function">7.105.2. SPACE Function</h4> <div class="paragraph"> <p>The SPACE function returns a character string consisting of a specified number of spaces, each of which is 0x20 or 0x0020, depending on the @@ -36303,7 +36359,7 @@ with the character set specified by <em>char-set-name</em>.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_space">7.104.3. Examples of SPACE</h4> +<h4 id="examples_of_space">7.105.3. Examples of SPACE</h4> <div class="ulist"> <ul> <li> @@ -36320,7 +36376,7 @@ with the character set specified by <em>char-set-name</em>.</p> </div> </div> <div class="sect2"> -<h3 id="sqrt_function">7.105. SQRT Function</h3> +<h3 id="sqrt_function">7.106. SQRT Function</h3> <div class="paragraph"> <p>The SQRT function returns the square root of a numeric value expression. SQRT is a Trafodion SQL extension.</p> @@ -36343,7 +36399,7 @@ negative number. See <a href="#numeric_value_expressions">Numeric Value Expressi </ul> </div> <div class="sect3"> -<h4 id="examples_of_sqrt">7.105.1. Examples of SQRT</h4> +<h4 id="examples_of_sqrt">7.106.1. Examples of SQRT</h4> <div class="ulist"> <ul> <li> @@ -36361,7 +36417,7 @@ approximately 5.196:</p> </div> </div> <div class="sect2"> -<h3 id="stddev_function">7.106. STDDEV Function</h3> +<h3 id="stddev_function">7.107. STDDEV Function</h3> <div class="paragraph"> <p>STDDEV is an aggregate function that returns the standard deviation of a set of numbers. STDDEV is a Trafodion SQL extension.</p> @@ -36407,7 +36463,7 @@ evaluation of <em>weight</em> must have the same cardinality.</p> </ul> </div> <div class="sect3"> -<h4 id="considerations_for_stddev">7.106.1. Considerations for STDDEV</h4> +<h4 id="considerations_for_stddev">7.107.1. Considerations for STDDEV</h4> <div class="sect4"> <h5 id="definition_of_stddev">Definition of STDDEV</h5> <div class="paragraph"> @@ -36459,7 +36515,7 @@ of STDDEV(x), a numeric overflow occurs.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_stddev">7.106.2. Examples of STDDEV</h4> +<h4 id="examples_of_stddev">7.107.2. Examples of STDDEV</h4> <div class="ulist"> <ul> <li> @@ -36497,7 +36553,7 @@ inventory:</p> </div> </div> <div class="sect2"> -<h3 id="substring_function">7.107. SUBSTRING/SUBSTR Function</h3> +<h3 id="substring_function">7.108. SUBSTRING/SUBSTR Function</h3> <div class="paragraph"> <p>The SUBSTRING function extracts a substring out of a given character expression. It returns a character string of data type VARCHAR, with a @@ -36571,7 +36627,7 @@ and continuing until the end of the <em>character-expr</em> are returned.</p> </ul> </div> <div class="sect3"> -<h4 id="alternative_forms">7.107.1. Alternative Forms</h4> +<h4 id="alternative_forms">7.108.1. Alternative Forms</h4> <div class="ulist"> <ul> <li> @@ -36599,7 +36655,7 @@ database software already supports SUBSTRING (<em>string</em>, <em>Fromint</em>, </div> </div> <div class="sect3"> -<h4 id="considerations_for_substring">7.107.2. Considerations for SUBSTRING/SUBSTR</h4> +<h4 id="considerations_for_substring">7.108.2. Considerations for SUBSTRING/SUBSTR</h4> <div class="sect4"> <h5 id="requirements_for_the_expression_length_and_start_position">Requirements for the Expression, Length, and Start Position</h5> <div class="ulist"> @@ -36628,7 +36684,7 @@ an up-shifted VARCHAR type.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_substring">7.107.3. Examples of SUBSTRING/SUBSTR</h4> +<h4 id="examples_of_substring">7.108.3. Examples of SUBSTRING/SUBSTR</h4> <div class="ulist"> <ul> <li> @@ -36700,7 +36756,7 @@ SUBSTR ('Robert John Smith' FROM 8 FOR 0)</code></pre> </div> </div> <div class="sect2"> -<h3 id="sum_function">7.108. SUM Function</h3> +<h3 id="sum_function">7.109. SUM Function</h3> <div class="paragraph"> <p>SUM is an aggregate function that returns the sum of a set of numbers.</p> </div> @@ -36735,7 +36791,7 @@ NULL. See <a href="#expressions">Expressions</a>.</p> </ul> </div> <div class="sect3"> -<h4 id="considerations_for_sum">7.108.1. Considerations for SUM</h4> +<h4 id="considerations_for_sum">7.109.1. Considerations for SUM</h4> <div class="sect4"> <h5 id="data_type_and_scale_of_the_result">Data Type and Scale of the Result</h5> <div class="paragraph"> @@ -36765,7 +36821,7 @@ SUM (PARTCOST * QTY_ORDERED)</code></pre> </div> </div> <div class="sect3"> -<h4 id="examples_of_sum">7.108.2. Examples of SUM</h4> +<h4 id="examples_of_sum">7.109.2. Examples of SUM</h4> <div class="ulist"> <ul> <li> @@ -36788,7 +36844,7 @@ SUM (PARTCOST * QTY_ORDERED)</code></pre> </div> </div> <div class="sect2"> -<h3 id="tan_function">7.109. TAN Function</h3> +<h3 id="tan_function">7.110. TAN Function</h3> <div class="paragraph"> <p>The TAN function returns the tangent of a numeric value expression, where the expression is an angle expressed in radians.</p> @@ -36814,7 +36870,7 @@ See <a href="#numeric_value_expressions">Numeric Value Expressions</a>.</p> </ul> </div> <div class="sect3"> -<h4 id="examples_of_tan">7.109.1. Examples of TAN</h4> +<h4 id="examples_of_tan">7.110.1. Examples of TAN</h4> <div class="ulist"> <ul> <li> @@ -36831,7 +36887,7 @@ approximately 0.3640, the tangent of 0.3491 (which is 20 degrees):</p> <div style="page-break-after: always;"></div> </div> <div class="sect3"> -<h4 id="tanh_function">7.109.2. TANH Function</h4> +<h4 id="tanh_function">7.110.2. TANH Function</h4> <div class="paragraph"> <p>The TANH function returns the hyperbolic tangent of a numeric value expression, where the expression is an angle expressed in radians.</p> @@ -36858,7 +36914,7 @@ function. See <a href="#numeric_value_expressions">Numeric Value Expressions</a> </div> </div> <div class="sect3"> -<h4 id="examples_of_tanh">7.109.3. Examples of TANH</h4> +<h4 id="examples_of_tanh">7.110.3. Examples of TANH</h4> <div class="ulist"> <ul> <li> @@ -36876,7 +36932,7 @@ approximately 0.8483, the hyperbolic tangent of 1.25:</p> </div> </div> <div class="sect2"> -<h3 id="this_function">7.110. THIS Function</h3> +<h3 id="this_function">7.111. THIS Function</h3> <div class="paragraph"> <p>The THIS function is a sequence function that is used in the ROWS SINCE function to distinguish between the value of the column in the current @@ -36904,7 +36960,7 @@ expression. If the value of the expression is null, THIS returns null.</p> </ul> </div> <div class="sect3"> -<h4 id="considerations_for_this">7.110.1. Considerations for THIS</h4> +<h4 id="considerations_for_this">7.111.1. Considerations for THIS</h4> <div class="sect4"> <h5 id="counting_the_rows">Counting the Rows</h5> <div class="paragraph"> @@ -36936,7 +36992,7 @@ THIS constant is reevaluated.</p> </div> </div> <div class="sect3"> -<h4 id="examples_of_this">7.110.2. Examples of THIS</h4> +<h4 id="examples_of_this">7.111.2. Examples of THIS</h4> <div class="ulist"> <ul> <li> @@ -36965,7 +37021,7 @@ rows_since_this </div> </div> <div class="sect2"> -<h3 id="timestampadd_function">7.111. TIMESTAMPADD Function</h3> +<h3 id="timestampadd_function">7.112. TIMESTAMPADD Function</h3> <div class="paragraph"> <p>The TIMESTAMPADD function adds the interval of time specified by <em>interval-ind</em> and <em>num_expr</em> to <em>datetime_expr</em>. If the specified @@ -37015,7 +37071,7 @@ returned.</p> </div> <div style="page-break-after: always;"></div> <div class="sect3"> -<h4 id="examples_of_timestampadd">7.111.1. Examples of TIMESTAMPADD</h4> +<h4 id="examples_of_timestampadd">7.112.1. Examples of TIMESTAMPADD</h4> <div class="ulist"> <ul> <li> @@ -37080,7 +37136,7 @@ returned.</p> </div> </div> <div class="sect2"> -<h3 id="timestampdiff_function">7.112. TIMESTAMPDIFF Function</h3> +<h3 id="timestampdiff_function">7.113. TIMESTAMPDIFF Function</h3> <div class="paragraph"> <p>The TIMESTAMPDIFF function returns the integer value for the number of <em>interval-ind</em> units of time between <em>startdate</em> and <em>enddate</em>. If @@ -37145,7 +37201,7 @@ January 7 of the year 0001.</p> </div> <div style="page-break-after: always;"></div> <div class="sect3"> -<h4 id="examples_of_timestampdiff">7.112.1. Examples of TIMESTAMPDIFF</h4> +<h4 id="examples_of_timestampdiff">7.113.1. Examples of TIMESTAMPDIFF</h4> <div class="ulist"> <ul> <li> @@ -37209,7 +37265,7 @@ crossed:</p> </div> </div> <div class="sect2"> -<h3 id="to_date_function">7.113. TO_DATE Function</h3> +<h3 id="to_date_function">7.114. TO_DATE Function</h3> <div class="paragraph"> <p>The TO_DATE function converts a character value to a dat
<TRUNCATED>