Re: [PATCH] by request: base64 for bytea

> On Sat, Jun 23, 2001 at 08:42:46AM -0400, Alex Pilosov wrote:
> > On Sat, 23 Jun 2001, Marko Kreen wrote:
> > > Or I can extract it out from pgcrypto and submit to core ;)
> > > I simply had not a need for it because I used those with
> > > pgcrypto, but Alex seems to hint that there would be bit of
> > > interest otherwise too.
> > I think encode/decode should be part of core, as they are basic functions
> > to manipulate bytea data...
> 
> Ok, I think I look into it.  I am anyway preparing a big update
> to pgcrypto.
> 
> Question to -hackers: currently there is not possible to cast
> bytea to text and vice-versa.  Is this intentional or bug?
> 
> It is weird because internal representation is exactly the same.
> As I want my funtions to operate on both, do I need to create
> separate funtion entries to every combination of parameters?
> It gets crazy on encrypt_iv(data, key, iv, type) which has 3
> parameters that can be both bytea or text...

I have commited code to CVS to make bytea binary compatible with text.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026