inet type and network()

From: "Daniel J(dot) Kressin" <dkressin(at)globalcrossing(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: inet type and network()
Date: 2001-03-15 03:03:29
Message-ID: 3AB03101.DA4CE625@globalcrossing.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

My table contains the following rows in a column of type inet:
ip
-------------
10.24.4.0/22
10.24.4.10/22
10.24.5.0/22
10.24.5.5/22

When I do a select, the rows come up as:
ip
--------------
10.24.4/22
10.24.4.10/22
10.24.5/22
10.24.5.5/22

The .0s get dropped. Is there a way to force it to leave the .0s
attached?
--
Dan
____ Kressin ____ .-----------------------------------.
/___ \____________/ __ \ | Unix SysAdmin |
\ \ / / \ | | Global Crossing |
___/ __\/\/rench_ \__/ | | dkressin(at)globalcrossing(dot)com |
\____/ \____/ | http://www.vib.org/wrench/ |
`-----------------------------------'

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-03-15 04:20:30 Re: inet type and network()
Previous Message Willis, Ian (Ento, Canberra) 2001-03-15 02:26:51 RE: Re: Fast Inserts and Hardware Questions