Hello The release notes of PostgreSQL 9.2 praise "SP-GIST" as a major feature but I cannot find any information on how to actually use it.
The main documentation seems unusual low level and the examples chapter just refers to the source code. The only examples I can find there are the regression tests. In those I stumbled across the "~>=~" operator. How does it differ from the normal ">="? (kind of hard to google for this string :)) SP-GIST should be good at "suffix search", I read. What exactly is meant here? I assume its not suffix as in "LIKE '%foo'". I'm interested because I heavily use the prefix_range extension for phone number searching. Could I somehow benefit from a SP-GIST suffix index (maybe by reversing my numbers)? thanks for any comments! bye, -christian- -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
