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
