inet/cidr wierdness (casting)
In case Tom isn't sick of me yet...
users=# select '10.1.2.3/24'::inet::cidr;
?column?
-------------
10.1.2.3/24
while:
users=# select '10.1.2.3/24'::cidr;
ERROR: invalid CIDR value '10.1.2.3/24': has bits set to right of mask
Apparently, since there's no explicit function to cast from inet to cidr,
postgresql assumes its always safe to do so, as they are
binary-compatible. Anyone mind if I create explicit function for this so
this could be flagged as error?
-alex
Alex Pilosov <alex@pilosoft.com> writes:
Apparently, since there's no explicit function to cast from inet to cidr,
postgresql assumes its always safe to do so, as they are
binary-compatible.
Yes. I've thought for awhile that it was a mistake to treat them as
binary-compatible. However, you'd need a lot more operator/function
declarations if they're not so marked.
Anyone mind if I create explicit function for this so
this could be flagged as error?
Won't help if they are binary compatible...
regards, tom lane