Jonah H. Harris wrote:
I'm willing to move soundex and metaphone into the backend. Does anyone see a reason not to do so?
As a kinda strange reason, I like them in contrib because they demonstrate a nice simple example of how one can write a contrib extension. This module has simple functions that take a string or two and return a string or number. Most of the other contrib modules do tricky stuff with weird types or indexes that make them rather complex to use as a starting point. If they were to be moved out of contrib, I think it'd be really nice if someone add a "hello_world" contrib that demonstrates a bunch of simple operations in C to be used as such a model. ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match