Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-8.x)/ SQL Reference/ Functions and Operators/ Range Functions and Operators/ Range Functions

Updated on 2025-05-29 GMT+08:00

View PDF

Range Functions

The lower and upper functions return null if the range is empty or the requested bound is infinite. The lower_inc, upper_inc, lower_inf, and upper_inf functions all return false for an empty range.

numrange(numeric, numeric, [text])

Description: Specifies a range.

Return type: range's element type

Example:

    
         gaussdb=# SELECT numrange(1.1,2.2) AS RESULT;
 result 
--------
[1.1,2.2)
(1 row)
gaussdb=# SELECT numrange(1.1,2.2, '()') AS RESULT;
 result 
--------
(1.1,2.2)
(1 row)

lower(anyrange)

Description: Lower bound of a range

Return type: range's element type

Example:

    
         gaussdb=# SELECT lower(numrange(1.1,2.2)) AS RESULT;
 result 
--------
    1.1
(1 row)

upper(anyrange)

Description: Upper bound of a range

Return type: range's element type

Example:

    
         gaussdb=# SELECT upper(numrange(1.1,2.2)) AS RESULT;
 result 
--------
    2.2
(1 row)

isempty(anyrange)

Description: Is the range empty?

Return type: Boolean

Example:

    
         gaussdb=# SELECT isempty(numrange(1.1,2.2)) AS RESULT;
 result 
--------
 f
(1 row)

lower_inc(anyrange)

Description: Is the lower bound inclusive?

Return type: Boolean

Example:

    
         gaussdb=# SELECT lower_inc(numrange(1.1,2.2)) AS RESULT;
 result 
--------
 t
(1 row)

upper_inc(anyrange)

Description: Is the upper bound inclusive?

Return type: Boolean

Example:

    
         gaussdb=# SELECT upper_inc(numrange(1.1,2.2)) AS RESULT;
 result 
--------
 f
(1 row)

lower_inf(anyrange)

Description: Is the lower bound infinite?

Return type: Boolean

Example:

    
         gaussdb=# SELECT lower_inf('(,)'::daterange) AS RESULT;
 result 
--------
 t
(1 row)

upper_inf(anyrange)

Description: Is the upper bound infinite?

Return type: Boolean

Example:

    
         gaussdb=# SELECT upper_inf('(,)'::daterange) AS RESULT;
 result 
--------
 t
(1 row)

elem_contained_by_range(anyelement, anyrange)

Description: Determines whether an element is within the range.

Return type: Boolean

Example:

gaussdb=# SELECT elem_contained_by_range('2', numrange(1.1,2.2));
 elem_contained_by_range
-------------------------
 t
(1 row)

in_range_int16_int16(int16, int16, int16, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int16_int16(1::int16, 1::int16, 1::int16, true, true);
 in_range_int16_int16 
----------------------
 f
(1 row)

gaussdb=# SELECT in_range_int16_int16(1::int16, 4::int16, 2::int16, true, true);
 in_range_int16_int16 
----------------------
 t
(1 row)

in_range_int8_int16(int8, int8, int16, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int8_int16(1::int8, 1::int8, 1::int16, true, true);
 in_range_int8_int16 
---------------------
 f
(1 row)

gaussdb=# SELECT in_range_int8_int16(1::int8, 4::int8, 2::int16, true, true);
 in_range_int8_int16 
---------------------
 t
(1 row)

in_range_int4_int16(int4, int4, int16, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int4_int16(1::int4, 1::int4, 1::int16, true, true);
 in_range_int4_int16 
---------------------
 f
(1 row)

gaussdb=# SELECT in_range_int4_int16(1::int4, 4::int4, 2::int16, true, true);
 in_range_int4_int16 
---------------------
 t
(1 row)

in_range_int2_int16(int2, int2, int16, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int2_int16(1::int2, 1::int2, 1::int16, true, true);
 in_range_int2_int16 
---------------------
 f
(1 row)

gaussdb=# SELECT in_range_int2_int16(1::int2, 4::int2, 2::int16, true, true);
 in_range_int2_int16 
---------------------
 t

in_range_int1_int16(int1, int1, int16, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

gaussdb=# SELECT in_range_int1_int16(1::int1, 1::int1, 1::int16, true, true);
 in_range_int1_int16 
---------------------
 f
(1 row)

gaussdb=# SELECT in_range_int1_int16(1::int1, 4::int1, 2::int16, true, true);
 in_range_int1_int16 
---------------------
 t
(1 row)

in_range_float8_float8(float8, float8, float8, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_float8_float8(1.0::float8, 1.9::float8, 1.0::float8, true, true);
 in_range_float8_float8 
------------------------
 f
(1 row)

in_range_float4_float8(float4, float4, float8, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_float4_float8(1.0::float4, 1.9::float4, 1.0::float8, true, true);
 in_range_float4_float8 
------------------------
 f
(1 row)

in_range_numeric_numeric(numeric, numeric, numeric, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_numeric_numeric(1.0::numeric(10,4), 1.9::numeric(10,4), 1.0::numeric(10,4), true, true);
 in_range_numeric_numeric 
--------------------------
 f
(1 row)

in_range_interval_interval(interval, interval, interval, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_interval_interval(interval '13' hour, interval '10' hour, interval '3' hour, false, true);
 in_range_interval_interval 
----------------------------
 t
(1 row)

in_range_timestamp_interval(timestamp, timestamp, interval, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

gaussdb=# SELECT in_range_timestamp_interval('12-10-2010 11:25:00', '10-11-2010 11:26:00', interval '60' day, false, true);
 in_range_timestamp_interval 
-----------------------------
 t
(1 row)

in_range_timestamptz_interval(timestamptz, timestamptz, interval, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_timestamptz_interval('12-10-2010 11:25:00+00', '10-11-2010 11:26:00+00', interval '60' day, false, true);
 in_range_timestamptz_interval 
-------------------------------
 t
(1 row)

in_range_time_interval(time, time, interval, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_time_interval('00:00:00', '12:00:00', interval '13' hour, true, true);
 in_range_time_interval 
------------------------
 f
(1 row)

in_range_timetz_interval(timetz, timetz, interval, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_timetz_interval('00:00:00+00', '12:00:00+00', interval '13' hour, true, true);
 in_range_timetz_interval 
--------------------------
 f
(1 row)

in_range_int8_numeric(int8, int8, numeric, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int8_numeric(1::int8, 2::int8, 0.9::numeric(10,4), true, true);
 in_range_int8_numeric 
-----------------------
 t
(1 row)

in_range_int4_numeric(int4, int4, numeric, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int4_numeric(1::int4, 2::int4, 0.9::numeric(10,4), true, true);
 in_range_int4_numeric 
-----------------------
 t
(1 row)

in_range_int2_numeric(int2, int2, numeric, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int2_numeric(1::int2, 2::int2, 0.9::numeric(10,4), true, true);
 in_range_int2_numeric 
-----------------------
 t
(1 row)

in_range_int1_numeric(int1, int1, numeric, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int1_numeric(1::int1, 2::int1, 0.9::numeric(10,4), true, true);
 in_range_int1_numeric 
-----------------------
 t
(1 row)

in_range_numeric_float4(numeric, numeric, float4, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_numeric_float4(1.0::numeric(10,4), 1.9::numeric(10,4), 1.0::float4, true, true);
 in_range_numeric_float4 
-------------------------
 f
(1 row)

in_range_numeric_float8(numeric, numeric, float8, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_numeric_float8(1.0::numeric(10,4), 1.9::numeric(10,4), 1.0::float8, true, true);
 in_range_numeric_float8 
-------------------------
 f
(1 row)

in_range_int8_float8(int8, int8, float8, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int8_float8(1::int8, 2::int8, 0.9::float8, true, true);
 in_range_int8_float8 
----------------------
 t
(1 row)

in_range_int4_float8(int4, int4, float8, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int4_float8(1::int4, 2::int4, 0.9::float8, true, true);
 in_range_int4_float8 
----------------------
 t
(1 row)

in_range_int2_float8(int2, int2, float8, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int2_float8(1::int2, 2::int2, 0.9::float8, true, true);
 in_range_int2_float8 
----------------------
 t
(1 row)

in_range_int1_float8(int1, int1, float8, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int1_float8(1::int1, 2::int1, 0.9::float8, true, true);
 in_range_int1_float8 
----------------------
 t
(1 row)

in_range_float8_int16(float8, float8, int16, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_float8_int16(1.0::float8, 1.9::float8, 1::int16, true, true);
 in_range_float8_int16 
-----------------------
 f
(1 row)

in_range_float4_int16(float4, float4, int16, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_float4_int16(1.0::float4, 1.9::float4, 1::int16, true, true);
 in_range_float4_int16 
-----------------------
 f
(1 row)

in_range_float8_int8(float8, float8, int8, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_float8_int8(1.0::float8, 1.9::float8, 1::int8, true, true);
 in_range_float8_int8 
----------------------
 f
(1 row)

in_range_float4_int8(float4, float4, int8, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_float4_int8(1.0::float4, 1.9::float4, 1::int8, true, true);
 in_range_float4_int8 
----------------------
 f
(1 row)

in_range_float8_int4(float8, float8, int4, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_float8_int4(1.0::float8, 1.9::float8, 1::int4, true, true);
 in_range_float8_int4 
----------------------
 f
(1 row)

in_range_float4_int4(float4, float4, int4, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_float4_int4(1.0::float4, 1.9::float4, 1::int4, true, true);
 in_range_float4_int4 
----------------------
 f
(1 row)

in_range_float8_int2(float8, float8, int2, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_float8_int2(1.0::float8, 1.9::float8, 1::int2, true, true);
 in_range_float8_int2 
----------------------
 f
(1 row)

in_range_float4_int2(float4, int2, int2, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_float4_int2(1.0::float4, 1.9::float4, 1::int2, true, true);
 in_range_float4_int2 
----------------------
 f
(1 row)

in_range_float8_int1(float8, float8, int1, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_float8_int1(1.0::float8, 1.9::float8, 1::int1, true, true);
 in_range_float8_int1 
----------------------
 f
(1 row)

in_range_float4_int1(float4, float4, int1, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_float4_int1(1.0::float4, 1.9::float4, 1::int1, true, true);
 in_range_float4_int1 
----------------------
 f
(1 row)

in_range_float8_float4(float8, float8, float4, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_float8_float4(1.0::float8, 1.9::float8, 1.0::float4, true, true);
 in_range_float8_float4 
------------------------
 f
(1 row)

in_range_float4_float4(float4, float4, float4, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_float4_float4(1.0::float4, 1.9::float4, 1.0::float4, true, true);
 in_range_float4_float4 
------------------------
 f
(1 row)

in_range_float8_numeric(float8, float8, numeric, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_float8_numeric(1.0::float8, 1.9::float8, 1.0::numeric(10,4), true, true);
 in_range_float8_numeric 
-------------------------
 f
(1 row)

in_range_float4_numeric(float4, float4, numeric, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_float4_numeric(1.0::float4, 1.9::float4, 1.0::numeric(10,4), true, true);
 in_range_float4_numeric 
-------------------------
 f
(1 row)

in_range_numeric_int16(numeric, numeric, int16, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_numeric_int16(1.0::numeric(10,4), 1.9::numeric(10,4), 1.0::int16, true, true);
 in_range_numeric_int16 
------------------------
 f
(1 row)

in_range_numeric_int8(numeric, numeric, int8, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_numeric_int8(1.0::numeric(10,4), 1.9::numeric(10,4), 1.0::int8, true, true);
 in_range_numeric_int8 
-----------------------
 f
(1 row)

in_range_numeric_int4(numeric, numeric, int4, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_numeric_int4(1.0::numeric(10,4), 1.9::numeric(10,4), 1.0::int4, true, true);
 in_range_numeric_int4 
-----------------------
 f
(1 row)

in_range_numeric_int1(numeric, numeric, int1, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_numeric_int1(1.0::numeric(10,4), 1.9::numeric(10,4), 1.0::int1, true, true);
 in_range_numeric_int1 
-----------------------
 f
(1 row)

in_range_int8_int8(int8, int8, int8, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int8_int8(1::int8, 1::int8, 1::int8, true, true);
 in_range_int8_int8 
--------------------
 f
(1 row)

in_range_int4_int8(int4, int4, int8, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int4_int8(1::int4, 1::int4, 1::int8, true, true);
 in_range_int4_int8 
--------------------
 f
(1 row)

in_range_int2_int8(int2, int2, int8, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int2_int8(1::int2, 1::int2, 1::int8, true, true);
 in_range_int2_int8 
--------------------
 f
(1 row)

in_range_int1_int8(int1, int1, int8, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int1_int8(1::int1, 1::int1, 1::int8, true, true);
 in_range_int1_int8 
--------------------
 f
(1 row)

in_range_int8_int4(int8, int8, int4, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int8_int4(1::int8, 1::int8, 1::int4, true, true);
 in_range_int8_int4 
--------------------
 f
(1 row)

in_range_int4_int4(int4, int4, int4, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int4_int4(1::int4, 1::int4, 1::int4, true, true);
 in_range_int4_int4 
--------------------
 f
(1 row)

in_range_int2_int4(int2, int2, int4, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int2_int4(1::int2, 1::int2, 1::int4, true, true);
 in_range_int2_int4 
--------------------
 f
(1 row)

in_range_int1_int4(int1, int1, int4, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int1_int4(1::int1, 1::int1, 1::int4, true, true);
 in_range_int1_int4 
--------------------
 f
(1 row)

in_range_int8_int2(int8, int8, int2, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int8_int2(1::int8, 1::int8, 1::int2, true, true);
 in_range_int8_int2 
--------------------
 f
(1 row)

in_range_int4_int2(int4, int4, int2, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int4_int2(1::int4, 1::int4, 1::int2, true, true);
 in_range_int4_int2 
--------------------
 f
(1 row)

in_range_int2_int2(int2, int2, int2, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int2_int2(1::int2, 1::int2, 1::int2, true, true);
 in_range_int2_int2 
--------------------
 f
(1 row)

in_range_int1_int2(int1, int1, int2, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int1_int2(1::int1, 1::int1, 1::int2, true, true);
 in_range_int1_int2 
--------------------
 f
(1 row)

in_range_int8_int1(int8, int8, int1, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int8_int1(1::int8, 1::int8, 1::int1, true, true);
 in_range_int8_int1 
--------------------
 f
(1 row)

in_range_int4_int1(int4, int4, int1, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int4_int1(1::int4, 1::int4, 1::int1, true, true);
 in_range_int4_int1 
--------------------
 f
(1 row)

in_range_int2_int1(int2, int2, int1, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int2_int1(1::int2, 1::int2, 1::int1, true, true);
 in_range_int2_int1 
--------------------
 f
(1 row)

in_range_int1_int1(int1, int1, int1, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int1_int1(1::int1, 1::int1, 1::int1, true, true);
 in_range_int1_int1 
--------------------
 f
(1 row)

in_range_int8_float4(int8, int8, float4, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int8_float4(1::int8, 2::int8, 0.9::float4, true, true);
 in_range_int8_float4 
----------------------
 t
(1 row)

in_range_int4_float4(int4, int4, float4, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int4_float4(1::int4, 2::int4, 0.9::float4, true, true);
 in_range_int4_float4 
----------------------
 t
(1 row)

in_range_int2_float4(int2, int2, float4, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int2_float4(1::int2, 2::int2, 0.9::float4, true, true);
 in_range_int2_float4 
----------------------
 t
(1 row)

in_range_int1_float4(int1, int1, float4, boolean, boolean)

Description: Checks whether the first parameter is within the range of the second parameter plus or minus the third parameter.

Parameters:

The first parameter: It needs to be determined whether it is within a specific range.
The second parameter: It specifies the start value of the current range.
Third parameter: It is a range value, which must be a positive number.
Fourth parameter: It specifies whether the current operation is a subtraction or addition operation.
- TRUE: Compare the second parameter minus the third parameter with the first parameter.
- FALSE: Compare the second parameter plus the third parameter with the first parameter.
Fifth parameter: It compares the operation result of the second and third parameters with the first parameter.
- TRUE: Check whether the result is greater than the first parameter. If the result is greater than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.
- FALSE: Check whether the result is less than or equal to the first parameter. If the result is less than or equal to the first parameter, the return value of the function is TRUE. Otherwise, the return value of the function is FALSE.

Return type: Boolean

Example:

gaussdb=# SELECT in_range_int1_float4(1::int1, 2::int1, 0.9::float4, true, true);
 in_range_int1_float4 
----------------------
 t
(1 row)

Parent topic: Range Functions and Operators

Previous topic: Range Operators

Next topic: Aggregate Functions

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.

Chatbot