On Thu, Dec 22, 2005 at 11:24:12AM +0100, Guido Neitzer wrote:
> Hi.
>
> Is there a limitation of the length of a char or varchar(x) column
> for indexing?
For btrees at least, yes. Around a third of a page or about 2713 bytes
by default. For bigger things you probably want tsearch anyway.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.