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 по дате отправления: