↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Functions / Network Address Functions And Operators

Returns the network part of the address, zeroing out whatever is to the right of the netmask.

Reading PG 18current·documented in 27 of 27 versions, 7.1 to 20

Signatures & examples

network ( inet ) → cidr
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.)
network(inet '192.168.1.5/24') → 192.168.1.0/24
Version history 1
  1. 12 → 13 changed

Definition snapshot: b7bd9cda · English manual source