Hi,
In testing the regex engine, I found a strange case that puzzles me.
When a text string of a single space character is casted to a character,
I would assume the result to be, a space character,
but for some reason it's the null character.
Trying to produce a text with null character gives an error, like expected:
SELECT chr(0);
ERROR: null character not permitted
SELECT c = ascii(chr(c)::char), COUNT(*) FROM generate_series(1,255) AS c GROUP BY 1;
f | 1
t | 254
SELECT * FROM generate_series(1,255) AS c WHERE c <> ascii(chr(c)::char);
32
It's only character 32 that has this "special effect".
/Joel