> Hi,
>
> my task is to search partial text in the fields mentioned in query.
Basically I have to tables t1 and t2 and I need to search in t1 all the
codes returned by a query from t2. In t1 the values could be identical as
in t2 or could be partial. For example.
>
> T1:
>
> Description
>
> 190201
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 f
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
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