Re: Casting varchar to bytea

On Friday 12 September 2003 20:39, Dylan Milks wrote:
> Hi. Could someone please tell me how to convert a "varchar" to a "bytea"
> datatype.
>
> I have a column which contains a number stored as a varchar. I have another
> column of type bytea. I'm trying to insert the value of the varchar column
> in the bytea column, but the conversion won't work.
>
> Something like the following:
>
> update webuser set ccnum = ccnumstring::bytea where userid=userid;
>
> Any ideas how to do this?

Does

update webuser set ccnum = decode(ccnumstring::text, 'encode')

work?

Ian Barwick
barwick(at)gmx(dot)net