Re: bytea_ops

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Joe Conway <joseph(dot)conway(at)home(dot)com>
Cc: PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: bytea_ops
Date: 2001-08-13 19:06:29
Message-ID: 200108131906.f7DJ6UK02173@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)postgresql(dot)org

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

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Paul Ramsey 2001-08-13 19:31:31 PostGIS spatial extensions
Previous Message Tom Lane 2001-08-13 18:48:17 Re: bytea_ops