"Reid Thompson" <Reid.Thompson@xxxxxxxx> writes: > is this the expected result? i.e. in the past was the result incorrect? > or is there a configuration param that controls this? Yes, yes, and no. You could change the pg_cast entry for char-to-text if you wanted, but then you would run into the other unpleasant cases that prompted us to change it in the first place. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster