Hello folks, I just bumped into a situation where I wanted to do a little macaddr arithmetic in postgres. I note that the inet type has support for bitwise AND, OR and NOT, as well as subtraction, but macaddr has none of the above.
These operations are easy to perform in C, but relatively a pain to do in SQL, especially as there doesn't seem to be a direct way to get a macaddr into a plain numeric form. I can't see any reason why postgres shouldn't support these operations on macaddr. I'd like to add them as fully realised operators in core. Would that be acceptable? Cheers, BJ -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers