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...

We just need to mark them as binary compatible. I will do that now and
commit. We really weren't sure what bytea was for in the past (or
forgot) so I am sure it was an oversight.

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