Re: FTS question

On Tue, Jul 01, 2008 at 01:14:12AM -0700, Damjan Rems wrote:
> Id would like to get aproximatly this.
> WHERE name LIKE 'somes%'
> But how do I construct FTS query for this?

for this - you dont need ftps. you just need proper index.

there will be prefix searches in full text indexes in postgresql 8.4:
http://www.depesz.com/index.php/2008/05/17/waiting-for-84-partial-match-support-in-gin-and-sequence-restart/

in the mean time you might want to check:
http://www.depesz.com/index.php/2007/09/15/speeding-up-like-xxx/

but if you really always have things like "name like 'somes%' - ie.
column like 'prefix-search%'; then all you need is simple btree index on
name column.

Best regards,

depesz