Re: How to cast VARCHAR to BYTEA and vice-versa?

Thank you, Tom.

Yes, the exact bytes in the varchar datum (without encoding) is what I would
like to become the bytes in the BYTEA.

So, how do I create a "cast WITHOUT FUNCTION" as you mention below? I assume
plpgsql is required, right?

Is there anyway this can be done in a VIEW without having to use plpgsql in
a Function (a.k.a. stored procedure)?

Is there no simple cast or conversion method I can call that does this for
me?

Best Regards,
Michael Moran

_____

From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Tue 3/8/2005 9:18 AM
To: Moran.Michael
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] How to cast VARCHAR to BYTEA and vice-versa?

"Moran.Michael" <Michael(dot)Moran(at)IGT(dot)com> writes:
> How do I cast VARCHAR to BYTEA?

I think it would work to create a cast WITHOUT FUNCTION, assuming that
the semantics you want is that the exact bytes in the varchar datum
become the bytes in the bytea (no encoding or backslashing conversions).

regards, tom lane