Ipv6 address stored differently while using Inet type

From: Sameer Thakur <samthakur74(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Ipv6 address stored differently while using Inet type
Date: 2018-12-27 09:26:25
Message-ID: CABzZFEvZWETyU=g4Ycq2O2fGDv=AfDFEAd-Udb5JeUknzrF3bA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
I am using Postgres 10.4
I tried to insert ipv6 address '2001:db8:3333:4444:5555:6666:1.2.3.4'
in Postgres (10.4) in an inet column. It is stored as
2001:db8:3333:4444:5555:6666:102:304.
Why is the IP stored differently?
Does the stored IP represent the same one being inserted?
Is this a known bug resolved in later versions of Postgres?
Thank you
Sameer

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter J. Holzer 2018-12-27 13:45:13 Re: Ipv6 address stored differently while using Inet type
Previous Message Mitar 2018-12-27 09:14:47 Re: Watching for view changes