Re: partial index on a text field
От | Chris |
---|---|
Тема | Re: partial index on a text field |
Дата | |
Msg-id | 001d01c4ba47$dec71590$0d00a8c0@chris обсуждение исходный текст |
Ответ на | Re: partial index on a text field (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-general |
Hi Tom, Perfect, thanks :) I'll have another look at FTI now to see how it works (though from memory it's a tedious process to get up and running). Chris. -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Monday, October 25, 2004 1:57 PM To: Chris Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] partial index on a text field "Chris" <chris@interspire.com> writes: > chris=> create index blah on ff_index(substring(icontent, 0, 200)); > ERROR: syntax error at or near "(" at character 40 > I'm running v7.4.5. Put an extra set of parens around it: create index blah on ff_index((substring(icontent, 0, 200))); "substring" looks like a function invocation but it isn't exactly, so you have to treat this as a general expression index. (This little inconsistency is fixed for 8.0, btw.) Note that the index will only do you any good if your queries are specifically written as "substring(icontent, 0, 200) LIKE 'pattern'". I suspect that you should instead be looking at full-text-indexing methods (see contrib/tsearch2, for instance). regards, tom lane
В списке pgsql-general по дате отправления: