On Tue, Dec 13, 2011 at 2:16 PM, Brendan Jurd <direvus(at)gmail(dot)com> wrote:
> On 12 December 2011 15:59, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
>> 2011/12/12 Brendan Jurd <direvus(at)gmail(dot)com>:
>>> 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.
> Here is a patch for $SUBJECT. I merely added support for ~, & and |
> operators for the macaddr type. The patch itself is rather trivial,
> and includes regression tests and a doc update.
The patch looks fine except that it uses the OIDs already used in pg_proc.h.
Attached is the updated version of the patch, which fixes the above problem.
> For the documentation, I did think about adding a new table for the
> macaddr operators, but in the end decided it would probably be an
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
In response to
pgsql-hackers by date
|Next:||From: Heikki Linnakangas||Date: 2012-01-17 06:21:28|
|Subject: Re: foreign key locks, 2nd attempt|
|Previous:||From: Tom Lane||Date: 2012-01-17 05:33:22|
|Subject: Re: Should we add crc32 in libpgport? |