Re: bytea_ops - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: bytea_ops
Date
Msg-id 200108131906.f7DJ6UK02173@candle.pha.pa.us
Whole thread Raw
In response to Re: bytea_ops  ("Joe Conway" <joseph.conway@home.com>)
List pgsql-patches
Tom has applied your patch.

> > which categories are present in a column.  For bytea data, there are
> > no natural categories and thus no justification for extrapolating
> > byte-value distribution from the info available to scalarltsel.  So
> > I think there's no defensible argument for using anything but 0..255.
> > (I suppose we could consider adding more info to pg_statistic for these
> > types of columns, but I'm not eager to do that right at the moment.)
>
> Changes in this rev:
>
> - convert_byte_to_scalar uses 0..255 range always
> - eliminated convert_bytea_datum, just pass and use the Datums directly
>
> Results still look good on my random data and passes all regression tests.
>
> -- Joe
>

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

--
  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: Gerhard Häring
Date:
Subject: Fix for fetchone() and fetchmany() in Python interface
Next
From: Paul Ramsey
Date:
Subject: PostGIS spatial extensions