On Thu, 28 Feb 2008, Richard Greenwood wrote:
I am using text search across multiple columns. Two of the columns have values that have zero padding - sort of. The values look like R0001234 (1 char followed by 7 digits, zero padded). Users are accustom to searching with and without the zero padding (entering R0001234 or R1234 should return identical results). This is easy to accommodate when parsing user input for a single column, but text searching across multiple columns it is harder determine if a char/digit group should be padded. So far my best idea is to create a tsvector column containing both padded and non-padded versions of the value. i.e. put both R1234 and R0001234 into the tsvector column. This seems pretty brute force, and I am pretty new to text search, so I'd welcome any suggestions.
create your dictionary, which index R0001234 as R0001234 and R1234 Seems, dict_regex is your friend. http://vo.astronet.ru/arxiv/dict_regex.html
Thanks, Rich
Regards, Oleg _____________________________________________________________ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: oleg@xxxxxxxxxx, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83 ---------------------------(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
