Skip site navigation (1) Skip section navigation (2)

Text Search zero padding

From: "Richard Greenwood" <richard(dot)greenwood(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Text Search zero padding
Date: 2008-02-29 03:40:34
Message-ID: ae9185aa0802281940v23754426y39fac4c62e3c72f6@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
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.

Thanks,
Rich

-- 
Richard Greenwood
richard(dot)greenwood(at)gmail(dot)com
www.greenwoodmap.com

Responses

pgsql-general by date

Next:From: Tom LaneDate: 2008-02-29 05:19:05
Subject: Re: Text Search zero padding
Previous:From: Tim RuppDate: 2008-02-29 03:17:17
Subject: rule question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group