Re: Bug? Netmask of CIDR as TEXT has trailing masklen

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: nomad(at)null(dot)net
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Bug? Netmask of CIDR as TEXT has trailing masklen
Date: 2016-12-23 17:04:17
Message-ID: 12363.1482512657@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

nomad(at)null(dot)net writes:
> Ah, I just noticed that the return value of the netmask() function is
> of type 'inet' and that is (in my mind) where the actual issue is. A
> netmask may have the same underlying form and space requirements as an
> internet address or subnet, but it isn't really the same thing.

Maybe, but we're not going to invent a whole new datatype just to
represent that. Perhaps you would be happier using the masklen()
function.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Edmundo Robles 2016-12-23 18:55:41 Re: Er Data Modeller for PostgreSQL
Previous Message Chris Richards 2016-12-23 16:35:26 explain analyze showed improved results without changes, why?