Paul > That's really excellent, and boy I wish I knew what file I should be reading to know all these new features... what file should I be reading?
Probably the best one to look at is this one since it has examples as well. http://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.1 BTW: One feature I'm really excited about and itching to try with tiger_geocoder is the new trigram behavior If you have a trigram index in place A clause like this: animal LIKE '%elephant%' Is automagically an indexable check. That compounded with the new KNN features in trigram may mean I can get orders of magnitude improvements in speed in tiger_geocoder in 9.1 without breaking a sweat and still make it backwards compatible with older versions of PostgreSQL. Hmm I wonder if this would make PostgreSQL the first relational database where such a WHERE condition can use an index without resorting to cryptic full text search mumbo jumbo that is incosistent across databases. I don't know of any others that can. Thanks, Regina _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
