On Tuesday 27 April 2004 13:55, kumar wrote:
> Hi Richar,
Kumar - try to make sure you reply to the list.
> It didnt work for me.
>
> select encode('65536'::bytea,'UTF-8')
> ERROR: Cannot cast type integer to bytea
>
> select encode('65536'::bytea,'UTF-8')
> ERROR: No such encoding as 'UTF-8'
I think you're using the encode() function wrongly. The second parameter is
supposed to be something like "base64" or "hex". I'm not sure it makes sense
to try and cast an integer to a bytea either.
Can you say what you're trying to achieve here?
-- Richard Huxton Archonet Ltd