Re: Bytea binary compatible - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: Bytea binary compatible
Date
Msg-id 200106240243.f5O2h2s23137@candle.pha.pa.us
Whole thread Raw
In response to Re: Bytea binary compatible  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Bytea binary compatible  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Here is a patch to make bytea binary compatible with other text data
> > types.  Comments?
>
> No way!  Unless you propose to make the text types null-safe (which
> would mean such nontrivial projects as replacing strcoll()).
>
> The fact that the storage formats are both struct varlena does not
> mean that these types are interchangeable.  I fail to see where it'd
> be a good idea to mark them binary-compatible, even if there weren't
> serious implementation issues.

OK, code backed out.  If the storage formats are the same, doesn't that
make them binary compatibile.  I know the NULL issue though.  I think I
see what you mean, that a text function can't operate on a bytea field.

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

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bytea binary compatible
Next
From: Bruce Momjian
Date:
Subject: Re: Bytea binary compatible