partial TEXT search on an index - Mailing list pgsql-general

From Ow Mun Heng
Subject partial TEXT search on an index
Date
Msg-id 1238462459.5553.4.camel@localhost.localdomain
Whole thread Raw
Responses Re: partial TEXT search on an index  (Thomas Pundt <mlists@rp-online.de>)
List pgsql-general
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

eg:
select * from table where serial_number LIKE 'AAA%'

does not use the index. What Do i need to do to have it recognise the
"partial index?" (is it called?)

Thanks

pgsql-general by date:

Previous
From: Eric Smith
Date:
Subject: Re: running two servers on one machine
Next
From: Tom Lane
Date:
Subject: Re: pgstattuple triggered checkpoint failure and database outage?