hello
I can run your sql statement in PgAdmin,too.
so your statement should be OK!
Can you post more example about add to result, let us have idea about your
question.
I think you can try to set char(1) to char(2), try it will useful..
--
http://alumni.cyut.edu.tw
Open WebMail Project (http://openwebmail.org)