diff options
| author | randomdan <randomdan@localhost> | 2014-04-03 13:37:45 +0000 |
|---|---|---|
| committer | randomdan <randomdan@localhost> | 2014-04-03 13:37:45 +0000 |
| commit | f7636c20bbba4f288cb592950824da2a1fafb02d (patch) | |
| tree | 23093cef6553b3f10d9e7d789d935513bbb725d1 | |
| parent | Copy of schema with new functional FTS indexes (diff) | |
| download | gentoobrowse-f7636c20bbba4f288cb592950824da2a1fafb02d.tar.bz2 gentoobrowse-f7636c20bbba4f288cb592950824da2a1fafb02d.tar.xz gentoobrowse-f7636c20bbba4f288cb592950824da2a1fafb02d.zip | |
Index the correct columns in FTS
| -rw-r--r-- | gentoobrowse/datasources/schema.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/gentoobrowse/datasources/schema.sql b/gentoobrowse/datasources/schema.sql index 47761fc..0d62c3e 100644 --- a/gentoobrowse/datasources/schema.sql +++ b/gentoobrowse/datasources/schema.sql @@ -287,7 +287,7 @@ CREATE FUNCTION packagefts(p packages) RETURNS tsvector BEGIN RETURN (SETWEIGHT(TO_TSVECTOR('english', p.name), 'A') || SETWEIGHT(TO_TSVECTOR('english', p.description), 'B') || - SETWEIGHT(TO_TSVECTOR('english', COALESCE(p.description, '')), 'C')); + SETWEIGHT(TO_TSVECTOR('english', COALESCE(p.summary, '')), 'C')); END $$; |