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

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: "Moran(dot)Michael" <Michael(dot)Moran(at)IGT(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: How to cast VARCHAR to BYTEA and vice-versa?
Date: 2005-03-09 00:33:23
Message-ID: 20050309003323.GA12798@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Mar 08, 2005 at 02:16:52PM -0800, Moran.Michael wrote:

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

Did you check the reference page for CREATE CAST already?

--
Alvaro Herrera (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
"Por suerte hoy explotó el califont porque si no me habría muerto
de aburrido" (Papelucho)

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2005-03-09 01:10:30 Re: How to cast VARCHAR to BYTEA and vice-versa?
Previous Message Neil Conway 2005-03-09 00:02:16 Re: fool-toleranced optimizer