Postgres Pro
Downloads
Home   >   mailing lists

Re: How to cast VARCHAR to BYTEA and vice-versa? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: How to cast VARCHAR to BYTEA and vice-versa?
Date
Msg-id 8503.1110302316@sss.pgh.pa.us
Whole thread Raw
In response to How to cast VARCHAR to BYTEA and vice-versa?  ("Moran.Michael" <Michael.Moran@IGT.com>)
Responses Re: How to cast VARCHAR to BYTEA and vice-versa?
List pgsql-hackers
Tree view 
"Moran.Michael" <Michael.Moran@IGT.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

pgsql-hackers by date:

Previous
From: "Moran.Michael"
Date:
Subject: How to cast VARCHAR to BYTEA and vice-versa?
Next
From: "Moran.Michael"
Date:
Subject: Re: How to cast VARCHAR to BYTEA and vice-versa?