Re: [BUGS] BUG #14681: Erroneous modulo (%) result - Mailing list pgsql-bugs

On 2017-05-31 21:45:47 +0000, marc@daelemans.com wrote:
> The following bug has been logged on the website:
> 
> Bug reference:      14681
> Logged by:          Marc Daelemans
> Email address:      marc@daelemans.com
> PostgreSQL version: 9.6.3
> Operating system:   Win8.1 x64
> Description:        
> 
> select i, i&11 as j from generate_series ( 1, 100 ) i ;

Thats not the modulo operator?  You're binary bitwise and-ing i and the
number 11 here.

> generates correct results on Win7 SP1, x64; 16GB machine, and
> erroneous results on another PC (Win8.1, x64, GB RAM). 

Which results are you getting, and what you expecting?


Greetings,

Andres Freund


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs