Re: [GENERAL] Text Search zero padding

2008-02-29 Thread Oleg Bartunov
On Fri, 29 Feb 2008, Richard Huxton wrote: Oleg Bartunov wrote: On Thu, 28 Feb 2008, Richard Greenwood wrote: 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 p

Re: [GENERAL] Text Search zero padding

2008-02-29 Thread Richard Huxton
Oleg Bartunov wrote: On Thu, 28 Feb 2008, Richard Greenwood wrote: 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 tex

Re: [GENERAL] Text Search zero padding

2008-02-29 Thread Oleg Bartunov
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 paddi

Re: [GENERAL] Text Search zero padding

2008-02-28 Thread Tom Lane
"Richard Greenwood" <[EMAIL PROTECTED]> writes: > 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 zer

[GENERAL] Text Search zero padding

2008-02-28 Thread Richard Greenwood
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 iden