Re: Arithmetic operators for macaddr type - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Arithmetic operators for macaddr type
Date
Msg-id CAFj8pRBCghxmvDkJHZN-=h5i5dAXRWQyrkr4-ag=6DisvoDHiw@mail.gmail.com
Whole thread Raw
In response to Arithmetic operators for macaddr type  (Brendan Jurd <direvus@gmail.com>)
Responses Re: Arithmetic operators for macaddr type  (Brendan Jurd <direvus@gmail.com>)
List pgsql-hackers
2011/12/12 Brendan Jurd <direvus@gmail.com>:
> 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?

+1

Pavel

>
> Cheers,
> BJ
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers


pgsql-hackers by date:

Previous
From: Brendan Jurd
Date:
Subject: Arithmetic operators for macaddr type
Next
From: Shigeru Hanada
Date:
Subject: Re: WIP: Collecting statistics on CSV file data