Re: Inconsistencies in the behavior of CHR() function in PG.

2019-03-29 Thread Christoph Berg
Re: Prabhat Sahu 2019-03-29 > While trying to explore on CHR() function in PG, > I found that few of the ASCII values are returning hex number values(like > '\x08', '\x0B') > and few are executing within SQL (i.e. chr(9) => Horizontal tab, chr(10) > => Line feed) as below example. That's not a

Inconsistencies in the behavior of CHR() function in PG.

2019-03-29 Thread Prabhat Sahu
Hi All, While trying to explore on CHR() function in PG, I found that few of the ASCII values are returning hex number values(like '\x08', '\x0B') and few are executing within SQL (i.e. chr(9) => Horizontal tab, chr(10) => Line feed) as below example. postgres=# select 1|| chr(8)|| 2 ||