Re: [SQL] Btree index on varchar

2001-03-23 Thread Tom Lane
Alexaki Sofia <[EMAIL PROTECTED]> writes: > I have a question for Btree indexes on a varchar field. > Does postgres (7.0.2) uses a special encoding when creating > Btree indexes on varchar?? "Special encoding"? No ... a varchar is a varchar. > Is it much more efficient to create indexes on int

[SQL] Btree index on varchar

2001-03-23 Thread Alexaki Sofia
Hello, I have a question for Btree indexes on a varchar field. Does postgres (7.0.2) uses a special encoding when creating Btree indexes on varchar?? Is it much more efficient to create indexes on integer than on strings with average length 30 chars?? Thank you in advance for your help Regard