On Sun, 19 Aug 2001 20:59:35 +0000 (UTC), omid omoomi <oomoomi(at)hotmail(dot)com>:
> hi all,
> I have pg 7.0.3 installed. I can use ascii() to get the ascii code of a
> character but I can not use chr() to reverse the function... is it a matter
> of the pg version I have? If so, is there any other way to get the text from
> the ascii number?
Hmm.. works in 7.1.2:
select chr(65);
chr
-----
A
(1 row)
Have you tried it like that (selecting a constant?) Maybe it is
a problem with coercing the argument to the proper type...
Could also be new in 7.1 I do not know.