Re: [GENERAL] partial TEXT search on an index

Hi, Ow Mun Heng schrieb: I don't think I understand how PG implements fulltext searching or if my search actually needs to use fulltext search. No, that's something different. See the fine manual. basically, I have a btree index on a SERIAL_NUMBER which is of sort like ABC12345 or AAA123434

Re: [GENERAL] partial TEXT search on an index

On Tue, 31 Mar 2009, Thomas Pundt wrote: Hi, Ow Mun Heng schrieb: I don't think I understand how PG implements fulltext searching or if my search actually needs to use fulltext search. No, that's something different. See the fine manual. in 8.4 it will be possible to use prefix search in

[GENERAL] partial TEXT search on an index

I don't think I understand how PG implements fulltext searching or if my search actually needs to use fulltext search. basically, I have a btree index on a SERIAL_NUMBER which is of sort like ABC12345 or AAA123434 or AAB131441 I would like to have search on the specific text of the SERIAL_NUMBER