* Mirko Zeibig <[EMAIL PROTECTED]> [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 - [[EMAIL PROTECTED]|[EMAIL PROTECTED]] "I have the heart of a child; I keep it in a jar on my desk."
