Re: Indexes on Character Types

On Wed, Jul 28, 2004 at 12:31:00PM +0100, val@webtribe.net wrote:
> In the 7.3 documentation about character data types
> (http://www.postgresql.org/docs/7.3/static/datatype-
> character.html), it states:
>  "Tip: There are no performance differences between these* three
> types, apart from the increased storage size when using the
> blank-padded type."
> *referencing character, character varying and text data types
>
> Is that statement applicable to indexes applied to those
> columns?  Is there any difference in performance for an index
> applied to a character, character varying and text data type?

Yes, no.  Apart from the increased storage size when using the
blank-padded type.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Criptografía: Poderosa técnica algorítmica de codificación que es
empleada en la creación de manuales de computadores.