marcelo Cortez wrote:
>> Are you sure you tested with a real bytea field?
>
> Yeah , i store bytea using encode function , how you
> say .
No, you store using the decode function.
=> \df decode
List of functions
Schema | Name | Result data type | Argument data types
------------+--------+------------------+---------------------
pg_catalog | decode | bytea | text, text
> The field of my table is bytea type , and store real
> bytea data in this field.
> My problem is , i can't convert this field to text
> anymore, not function receiving bytea and return text
> exist's.
That's what your encode function should do.
=> \df encode
List of functions
Schema | Name | Result data type | Argument data types
------------+--------+------------------+---------------------
pg_catalog | encode | text | bytea, text
(1 row)
What does "\df encode" show for you?
--
Richard Huxton
Archonet Ltd