On Tue, 2005-07-19 at 05:42, Dennis Bjorklund wrote:
> On Mon, 18 Jul 2005, Jaime Casanova wrote:
>
> > I don't think you could create indexes on text fields... there are
> > other type of indexes for that... tsearch2 for example
>
> You can index text fields, but you can't insert values bigger then
> BLOCKSIZE/3 when you have an index on that column.]
Please note that the size limitation is for btree indexes, the most
common and well tested index types.
For hash you can have a much larger value, but only direct matching is
supported.
I don't know about GiST...
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
