Re: text and bytea

"hernan gonzalez" <hgonzalez@gmail.com> writes:

> IMHO, the semantics of encode() and decode() are correct (the bridge
> between bytea and text ... in the backend encoding; they should be the
> only bridge), convert() is also ok (deals with bytes), but
> convert_to() and convert_from() are dubious if not broken: they imply
> texts in arbitrary encodings (for output or input) , lead to
> anomalities and shouldnt be necessary at all.

postgres=# \df convert_from
                         List of functions
   Schema   |     Name     | Result data type | Argument data types
------------+--------------+------------------+---------------------
 pg_catalog | convert_from | text             | bytea, name
(1 row)

postgres=# \df convert_to
                        List of functions
   Schema   |    Name    | Result data type | Argument data types
------------+------------+------------------+---------------------
 pg_catalog | convert_to | bytea            | text, name
(1 row)


Looks like they produce and consume byteas to me.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's RemoteDBA services!