From 5cd226583a8a95fde17bc1616350070bbe9e60d2 Mon Sep 17 00:00:00 2001 From: randomdan Date: Wed, 9 Apr 2014 15:51:12 +0000 Subject: Remove fugly index definition with functional one --- p2pvr/datasources/schema.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/p2pvr/datasources/schema.sql b/p2pvr/datasources/schema.sql index df65cfa..fce7a4f 100644 --- a/p2pvr/datasources/schema.sql +++ b/p2pvr/datasources/schema.sql @@ -436,7 +436,7 @@ ALTER TABLE ONLY transportstreams -- Name: idx_event_search; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -CREATE INDEX idx_event_search ON events USING gin ((((setweight(to_tsvector('english'::regconfig, title), 'A'::"char") || setweight(to_tsvector('english'::regconfig, COALESCE(subtitle, ''::text)), 'B'::"char")) || setweight(to_tsvector('english'::regconfig, COALESCE(description, ''::text)), 'C'::"char")))); +CREATE INDEX idx_event_search ON events USING gin (event_tsvector(events.*)); -- -- cgit v1.2.3