Home / Search/ Language Reference/ Functions/ Scalar Functions/ INET Functions/ipv4_compare

ipv4_compare

The ipv4_compare function compares two IPv4 strings. The two IPv4 strings are parsed and compared while accounting for the combined IP-prefix mask calculated from argument prefixes, and the optional PrefixMask argument.

Syntax

    ipv4_compare( Expr1, Expr2 [, PrefixMask ] )

Arguments

  • Expr1, Expr2: A string expression representing an IPv4 address. Denote a subnet mask with a forward slash /.
  • PrefixMask: An integer from 0 to 32 representing the number of most-significant bits that are taken into account.

Results

  • 0: If the long representation of the first IPv4 string argument is equal to the second IPv4 string argument
  • 1: If the long representation of the first IPv4 string argument is greater than the second IPv4 string argument
  • -1: If the long representation of the first IPv4 string argument is less than the second IPv4 string argument
  • null: If conversion for one of the two IPv4 strings wasn’t successful.

Examples

  • ipv4_compare("127.0.0.1", "127.0.0.1") returns as 0
  • ipv4_compare('192.168.1.1', '192.168.1.255') returns as -1
  • ipv4_compare('192.168.1.1/24', '192.168.1.255/24') returns as 0
  • ipv4_compare('192.168.1.1', '192.168.1.255', 24) returns as 0