On Fri, 2009-10-02 at 02:17 +0000, Dan French wrote: > #1: bytea_string = '"0"' (table; bytea) > Function: > trim('"' both from bytea_string) > fails and returns: '"0'
Works for me. Please submit a complete test case. > #2: Come on folks: Bytea is a series of bytes. Conversion to ASCII is not > this difficult; and should (does) not require explicit type casts (esp since > they are already in ASCII) Converting between data types that have different semantics should always requires an explicit cast. This is to protect against accidental misinterpretation. There is ample discussion about that in the archives. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs