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

2018-01-21 Thread Craig Ringer
On 13 January 2018 at 01:57, Christian Rossow wrote: > Hi Fabien, > > > 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? > I aimed to close the asymmetry between bit vector operations (the

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

2018-01-12 Thread Christian Rossow
Hi Fabien, > 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? I aimed to close the asymmetry between bit vector operations (they also offer xor/and/etc.) and bytea operations. My code is more o

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

2018-01-12 Thread Komяpa
Hello, working with binary is certainly lacked in Postgres. I would be happy if these can be pulled in to Postgres, as there's not always a possibility to install a C based extension, and bit tricks are needed for efficient SQL-level implementations of custom datatypes. Another bitwise thing, w

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

2018-01-11 Thread Fabien COELHO
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