Re: bytea bitwise logical operations implementation (xor / and / or/ not)

Поиск
Список
Период
Сортировка
От Fabien COELHO
Тема Re: bytea bitwise logical operations implementation (xor / and / or/ not)
Дата
Msg-id alpine.DEB.2.20.1801120832550.3820@lancre
обсуждение исходный текст
Ответ на bytea bitwise logical operations implementation (xor / and / or /not)  (Christian Rossow <christian.rossow@gmail.com>)
Ответы Re: bytea bitwise logical operations implementation (xor / and / or / not)
Re: bytea bitwise logical operations implementation (xor / and / or /not)
Список pgsql-hackers
Hello Christian,

> Currently, `bytea` does not have any bitwise logical operations yet.
> This issue came up in an old thread from 2006 [1], but nobody seemed to
> have picked this issue so far.

I remember this one because I needed them for checksuming set of rows. 
There is a whole set of missing (from my point of view) operators, casts 
and aggregates.

See https://github.com/zx80/pg_comparator where I packaged the subset I 
needed as an extension. In particular, there is a bitxor which can be used 
for bytea if casting is allowed.

> Tested on PG 9.6. I hope you find this useful.

I think that the probability of getting these useful things into pg is 
alas small. In the mean time, you may package and register it as an 
extension?

-- 
Fabien.


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Etsuro Fujita
Дата:
Сообщение: Re: [HACKERS] postgres_fdw bug in 9.6
Следующее
От: Kyotaro HORIGUCHI
Дата:
Сообщение: Re: [HACKERS] [PATCH] Improve geometric types