Commit15f91f2

committed

Add GIN support for pg_trgm. From Guillaume Smet <guillaume.smet@gmail.com>

with minor editorization by me.

1 parent547e41c commit15f91f2Copy full SHA for 15f91f2

File tree

+1256

-5

lines changed

+1256

-5

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,7 +1,7 @@`
`1`		`-# $PostgreSQL: pgsql/contrib/pg_trgm/Makefile,v 1.6 2007/02/09 17:24:33 petere Exp $`
	`1`	`+# $PostgreSQL: pgsql/contrib/pg_trgm/Makefile,v 1.7 2007/03/14 14:15:40 teodor Exp $`
`2`	`2`
`3`	`3`	`MODULE_big = pg_trgm`
`4`		`-OBJS = trgm_op.o trgm_gist.o`
	`4`	`+OBJS = trgm_op.o trgm_gist.otrgm_gin.o`
`5`	`5`
`6`	`6`	`DATA_built = pg_trgm.sql`
`7`	`7`	`DATA = uninstall_pg_trgm.sql`

Lines changed: 2 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -113,6 +113,8 @@ Tsearch2 Integration`
`113`	`113`	`Next, create a trigram index on the word column:`
`114`	`114`
`115`	`115`	`CREATE INDEX words_idx ON words USING gist(word gist_trgm_ops);`
	`116`	`+or`
	`117`	`+CREATE INDEX words_idx ON words USING gin(word gist_trgm_ops);`
`116`	`118`
`117`	`119`	`Now, a SELECT query similar to the example above can be used to`
`118`	`120`	`suggest spellings for misspelled words in user search terms. A`

Comments

(0)