Eugene E. wrote:
> Alvaro Herrera wrote:
> >text is not bytea.
>
> source says:
>
> typedef text varlena;
> typedef bytea varlena;
This means that as far as the C type system is concerned, both bytea and
text are treated as "struct varlena". It doesn't mean that they are
processed by the same input/output functions, which they aren't.
NUL bytes are preserved in bytea, and used as terminators in text. I
don't find this surprising at all, do you?
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
