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 [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
