Re: Prabhat Sahu 2019-03-29 <CANEvxPqaQqojU+XyKrfiwt729P+ZikjYsfn=hqhezctkm5i...@mail.gmail.com> > 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 property of chr(), but generally of the "text" datatype: # select E'\002'::text; text ────── \x02 Non-printable characters are quoted. See also: # select i, chr(i) from generate_series(1, 256) g(i); Christoph
