It's not really the index's problem; IIUC the behavior of the gist and
gin index opclasses is not locale-specific.


It's the to_tsvector calls
that built the tsvector heap column that have a locale specified or
implicit.  We need some way of annotating the heap column about this.
It seems too restrictive to advanced users.

In the case of a functional index you can expose the locale:

        create index ... (to_tsvector('english'::regconfig, mytextcol))

but there's still the problem that the planner cannot match that to
a query specified as just WHERE to_tsvector(mytextcol) @@ query.

Teodor Sigaev                                   E-mail: [EMAIL PROTECTED]

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to