Hi!
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
> Possibly a binary cast (WITHOUT FUNCTION) would solve your problem,
> though I doubt it will work well on bytea values containing \0.
Thanks, I've been a bit thick here, but I just found the solution to my problem
- and
Hi!
-Original Message-
From: Ragnar Hafstað [mailto:[EMAIL PROTECTED]
>are you sure your problem is with pg_crypto ?
>what does this produce:
> select bytea2text('Tübingen'::bytea) as foo;
>?
Well I'm sure it's not WITH pgcrypto but with actually using pgcrypto in
conjunction with U
"Markus Wollny" <[EMAIL PROTECTED]> writes:
> ... I'am using the following function as workaround for a bytea-to-text-cast:
> create or replace function bytea2text(bytea) returns text as '
> begin
>return $1;
> end;
> ' language plpgsql;
That looks like your problem right there.
Possibly
On Mon, 2005-02-28 at 18:32 +0100, Markus Wollny wrote:
> To get straight to the point, here's my problem:
>
> mypgdb=# select bytea2text(decrypt(encrypt('Tübingen'::bytea,
> 'mypassphrase'::bytea,'bf'::text),'mypassphrase'::bytea,'bf'::text)) as foo;
>foo
> -
> T\303\274
Hello!
To get straight to the point, here's my problem:
mypgdb=# select bytea2text(decrypt(encrypt('Tübingen'::bytea,
'mypassphrase'::bytea,'bf'::text),'mypassphrase'::bytea,'bf'::text)) as foo;
foo
-
T\303\274bingen
(1 row)
I have compiled and installed pg_crypto and I
