Hannu Krosing <hannu(at)tm(dot)ee> writes:
> Also I remember being told that bytea _can_ hold embedded \0, no ?
Yes. What has that got to do with text et al?
>> Possibly chr() should reject chr(0) ...
>
> there is no function chr() at least in 7.0.2.
I think it used to be called ichar(), but then someone pointed out that
Oracle calls it chr().
> and char is not usable from psql (gives out strange errors);
char(n) is a type name, not a function call.
regards, tom lane