File: datatype1369.html

package info (click to toggle)
mpsql 2.1-2
links: PTS
area: non-free
in suites: potato
size: 3,528 kB
ctags: 4,886
sloc: ansic: 35,184; makefile: 3,761; sh: 44
file content (360 lines) | stat: -rw-r--r-- 5,038 bytes
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML
><HEAD
><TITLE
>IP Version 4 Networks and Host Addresses</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet version 1.19"><LINK
REL="HOME"
TITLE="PostgreSQL User's Guide"
HREF="user.html"><LINK
REL="UP"
TITLE="Data Types"
HREF="datatype.html"><LINK
REL="PREVIOUS"
TITLE="Geometric Types"
HREF="datatype1275.html"><LINK
REL="NEXT"
TITLE="Operators"
HREF="operators.html"></HEAD
><BODY
BGCOLOR="#FFFFFF"
TEXT="#000000"
><DIV
CLASS="NAVHEADER"
><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="3"
ALIGN="center"
>PostgreSQL User's Guide</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
HREF="datatype1275.html"
>Prev</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
>Chapter 5. Data Types</TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="operators.html"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
CLASS="SECT1"
><A
NAME="AEN1369"
>IP Version 4 Networks and Host Addresses</A
></H1
><P
>The <SPAN
CLASS="TYPE"
>cidr</SPAN
> type stores networks specified 
in <SPAN
CLASS="ACRONYM"
>CIDR</SPAN
> notation.
The <SPAN
CLASS="TYPE"
>inet</SPAN
> type stores hosts and networks in CIDR notation.</P
><P
><DIV
CLASS="TABLE"
><P
><B
>Table 5-14. <SPAN
CLASS="PRODUCTNAME"
>Postgres</SPAN
>IP Version 4 Types</B
></P
><TABLE
BORDER="1"
CLASS="CALSTABLE"
><TR
><TH
ALIGN="LEFT"
VALIGN="TOP"
>IPV4 Type</TH
><TH
ALIGN="LEFT"
VALIGN="TOP"
>Storage</TH
><TH
ALIGN="LEFT"
VALIGN="TOP"
>Description</TH
><TH
ALIGN="LEFT"
VALIGN="TOP"
>Range</TH
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
>cidr</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>variable</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>CIDR networks</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Valid IPV4 CIDR blocks</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
>inet</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>variable</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>nets and hosts</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>Valid IPV4 CIDR blocks</TD
></TR
></TABLE
></DIV
></P
><H2
CLASS="SECT2"
><A
NAME="AEN1398"
><SPAN
CLASS="TYPE"
>inet</SPAN
> for IP Networks</A
></H2
><P
>The cidr type holds a CIDR network.
The format for specifying networks is "x.x.x.x/y" where "x.x.x.x" is the
network and "/y" is the number of bits in the netmask.
If the "/y" part is left off, it is calculated using assumptions from
the old class system except that it is extended to include at least
all of the octets in the input.
Here are some examples:&#13;</P
><P
> 
<DIV
CLASS="TABLE"
><P
><B
>Table 5-15. <SPAN
CLASS="PRODUCTNAME"
>Postgres</SPAN
>IP Types Examples</B
></P
><TABLE
BORDER="1"
CLASS="CALSTABLE"
><TR
><TH
ALIGN="LEFT"
VALIGN="TOP"
>CIDR Input</TH
><TH
ALIGN="LEFT"
VALIGN="TOP"
>CIDR Displayed</TH
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
>192.168.1</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>192.168.1/24</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
>192.168</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>192.168.0/24</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
>128.1</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>128.1/16</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
>128</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>128.0/16</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
>128.1.2</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>128.1.2/24</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
>10.1.2</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>10.1.2/24</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
>10.1</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>10.1/16</TD
></TR
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
>10</TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
>10/8</TD
></TR
></TABLE
></DIV
></P
><H2
CLASS="SECT2"
><A
NAME="AEN1436"
><SPAN
CLASS="TYPE"
>inet</SPAN
> for IP Networks</A
></H2
><P
>The inet type is designed to hold, in one field, all of the information
about a host including the CIDR style subnet that it is in.
Note that if you want to store proper CIDR networks, see the cidr type.
The inet type is similar to the cidr type except that the bits in the
host part can be non-zero.
Functions exist to extract the various elements of the field.</P
><P
>  
The input format for this function is "x.x.x.x/y" where "x.x.x.x" is
an internet host and y is the number of bits in the netmask.
If the "/y" part is left off, it is treated as "/32."
On output, the "/y" part is not printed if it is /32.
This allows the type to be used as a straight host type by just leaving of
the bits part.</P
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="datatype1275.html"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="user.html"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="operators.html"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>Geometric Types</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="datatype.html"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>Operators</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>