On Fri, 2006-11-10 at 20:39 +0300, Teodor Sigaev wrote:
> >> Use @>, <@ operations instead of @ and ~
> >> Look for discussions in -hackers for reasons of changing names
> >
> > Ah, many thanks. How about updating those web pages? :)
> Now they are in core:
> http://developer.postgresql.org/pgdocs/postgres/functions-array.html
>
> >
> >> Pls, why don't you use tsearch2 with GIN?
> >
> > Perhaps -- is there any documentation on this?
> Nothing special, just use GIN index instead of GiST.
>
I think a section showing when to use GiST versus GIN would be very
helpful (assuming there are still good reasons to use GiST). I would
certainly read it.
It would also be helpful to update the docs to use GIN where
appropriate.
Regards,
Jeff Davis
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
