| PostgreSQL Reference Manual - Volume 1 - SQL Language Reference by The PostgreSQL Global Development Group Paperback (6"x9"), 716 pages ISBN 0954612027 RRP £32.00 ($49.95) Sales of this book support the PostgreSQL project! Get a printed copy>>> |
6.8.2 cidr
The cidr type holds an IPv4 or IPv6 network specification.
Input and output formats follow Classless Internet Domain Routing
conventions.
The format for specifying networks is address/y where address is the network represented as an
IPv4 or IPv6 address, and y is the number of bits in the netmask. If
y is omitted, it is calculated
using assumptions from the older classful network numbering system, except
that it will be at least large enough to include all of the octets
written in the input. It is an error to specify a network address
that has bits set to the right of the specified netmask.
Table 6-18 shows some examples.
Table 6-18:
cidr Type Input Examples
cidr Input | cidr Output | |
| 192.168.100.128/25 | 192.168.100.128/25 | 192.168.100.128/25
|
| 192.168/24 | 192.168.0.0/24 | 192.168.0/24
|
| 192.168/25 | 192.168.0.0/25 | 192.168.0.0/25
|
| 192.168.1 | 192.168.1.0/24 | 192.168.1/24
|
| 192.168 | 192.168.0.0/24 | 192.168.0/24
|
| 128.1 | 128.1.0.0/16 | 128.1/16
|
| 128 | 128.0.0.0/16 | 128.0/16
|
| 128.1.2 | 128.1.2.0/24 | 128.1.2/24
|
| 10.1.2 | 10.1.2.0/24 | 10.1.2/24
|
| 10.1 | 10.1.0.0/16 | 10.1/16
|
| 10 | 10.0.0.0/8 | 10/8
|
| 10.1.2.3/32 | 10.1.2.3/32 | 10.1.2.3/32
|
| 2001:4f8:3:ba::/64 | 2001:4f8:3:ba::/64 | 2001:4f8:3:ba::/64
|
| 2001:4f8:3:ba:2e0:81ff:fe22:d1f1/128 | 2001:4f8:3:ba:2e0:81ff:fe22:d1f1/128 | 2001:4f8:3:ba:2e0:81ff:fe22:d1f1
|
| ::ffff:1.2.3.0/120 | ::ffff:1.2.3.0/120 | ::ffff:1.2.3/120
|
| ::ffff:1.2.3.0/128 | ::ffff:1.2.3.0/128 | ::ffff:1.2.3.0/128 |
| ISBN 0954612027 | PostgreSQL Reference Manual - Volume 1 - SQL Language Reference | See the print edition |