Re: random generated string matching index in inexplicable ways

[Myles Miller]

> > # SELECT y FROM x WHERE y = chr(round(random())::int + 65);
> > y 
> > ---
> > A
> > B
> > (2 rows)
> Here you got a random value in the lower range of 0..1 for the record with 
> value ‘A’, so that’s a match, and one in the higher range for value ‘B’, a 
> match again, so you get 2 rows.

No, the function is returning just one letter, either 'A' or 'B', not multiple 
values.

# SELECT * FROM chr(round(random())::int + 65);
 chr
-----
 B
(1 row)

# SELECT * FROM chr(round(random())::int + 65);
 chr
-----
 A
(1 row)