↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / Functions

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.)

English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

group
net
group label
Network Address Functions And Operators
lang
en
layout
table-new
pages
functions-net.html
prose only
false

Definition PG 18

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.)

Signatures and overloads

network ( inet ) → cidr → 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.)

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:43a4da20b3a181d16e38358dd892b506d64b5678d95cb4c2f4ce6b65c974b42f

Text language: en · wiki-repair-20261023:43a4da20b3a181d16e38358dd892b506d64b5678d95cb4c2f4ce6b65c974b42f