Module diesel::pg::expression::functions

source ·
Available on crate feature postgres_backend only.
Expand description

PostgreSQL specific functions

Functions§

  • abbrev
    Creates an abbreviated display format as text.
  • array_append
    Append an element to the end of an array
  • array_cat
    Concatenates two arrays
  • array_dims
    Returns a text representation of the array’s dimensions
  • array_fill
    Returns an array initialized with supplied value and dimensions, optionally with lower bounds other than 1. This function omits the optional lower bound argument. See [array_fill_with_lower_bound] for that.
  • array_fill_with_lower_bound
    Returns an array initialized with supplied value and dimensions, with lower bounds other than 1
  • array_length
    Returns the length of the requested array
  • array_lower
    Returns the lower bound of the requested array
  • array_ndims
    Returns the number of dimensions of the array
  • array_position
    Returns the subscript of the first occurrence of the second argument in the array, or NULL if it’s not present. If the third argument is given, the search begins at that subscript. This function omits the third argument. See [array_position_with_subscript].
  • array_position_with_subscript
    Returns the subscript of the first occurrence of the second argument in the array, or NULL if it’s not present, beginning at the subscript given as the third argument.
  • array_positions
    Returns an array of the subscripts of all occurrences of the second argument in the array given as first argument.
  • array_prepend
    Prepends an element to the beginning of an array
  • array_remove
    Removes all elements equal to the given value from the array
  • array_replace
    Replace all occurrences of an element in an array with a given element
  • array_shuffle
    Randomly shuffles the first dimension of the array.
  • array_to_string
    Converts each array element to its text representation and concatenates those elements separated by the delimiter string. NULL entries are omitted in this variant. See [array_to_string_with_null_string] for a variant with that argument.
  • array_to_string_with_null_string
    Converts each array element to its text representation and concatenates those elements separated by the delimiter string. If null_string is provided and is not NULL, then NULL array entries are represented by that string; otherwise, they are omitted.
  • array_upper
    Returns the upper bound of the requested array
  • broadcast
    Computes the broadcast address for the address’s network.
  • cardinality
    Returns the total number of elements in the array, or 0 if the array is empty.
  • daterange
    Returns range of dates
  • family
    Returns the address’s family: 4 for IPv4, 6 for IPv6.
  • host
    Returns the IP address as text, ignoring the netmask.
  • hostmask
    Computes the host mask for the address’s network.
  • inet_merge
    Computes the smallest network that includes both of the given networks.
  • inet_same_family
    Tests whether the addresses belong to the same IP family.
  • int4range
    Returns range of integer
  • int8range
    Returns range of big ints
  • isempty
    Returns true if the range is empty
  • lower
    Returns the lower bound of the range
  • lower_inc
    Returns true if the range’s lower bound is inclusive
  • lower_inf
    Returns true if the range’s lower bound is unbounded
  • masklen
    Returns the netmask length in bits.
  • multirange_merge
    Returns the smallest range which includes all ranges in the multirange
  • netmask
    Computes the network mask for the address’s network.
  • network
    Returns the network part of the address, zeroing out whatever is to the right of the netmask. (This is equivalent to casting the value to cidr.)
  • numrange
    Returns range of numeric values
  • range_merge
    Returns the smallest range which includes both of the given ranges
  • set_masklen
    Sets the netmask length for an inet or cidr value. For inet, the address part does not changes. For cidr, address bits to the right of the new netmask are set to zero.
  • to_json
    Converts any SQL value to json
  • trim_array
    Trims an array by removing the last n elements. If the array is multidimensional, only the first dimension is trimmed.
  • tsrange
    Returns range of timestamps without timezone
  • tstzrange
    Returns range of timestamps with timezone
  • upper
    Returns the upper bound of the range
  • upper_inc
    Returns true if the range’s upper bound is inclusive
  • upper_inf
    Returns true if the range’s upper bound is unbounded

Type Aliases§