* Mirko Zeibig <mirko@picard.inka.de> [010124 09:07] wrote:
> Hello,
>
> I have a table:
>
> CREATE TABLE pge (
> pge_id SERIAL,
> pge_path CHAR(255) CONSTRAINT ak_pge_path UNIQUE,
> PRIMARY KEY (pge_id)
> );
>
> >From other tables I now reference pge_id as well as pge_path. Somewhere I
> have read that indices on CHAR are faster than those on VARCHAR.
No clue, but as a somewhat related note, I don't think indexes work
properly when a join is attempted on a CHAR and VARCHAR column.
--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."