From 49584608efd7d3bd74c7a01301d902787776b5ef Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Thu, 16 Apr 2015 17:39:49 -0400 Subject: [PATCH] LP#1438136: Update baseline schema files Signed-off-by: Mike Rylander Signed-off-by: Chris Sharp Signed-off-by: Jason Stephenson --- .../src/sql/Pg/300.schema.staged_search.sql | 30 +++++++++++++++++++ 1 file changed, 30 insertions(+) diff --git a/Open-ILS/src/sql/Pg/300.schema.staged_search.sql b/Open-ILS/src/sql/Pg/300.schema.staged_search.sql index 5907e05218..cb4338483b 100644 --- a/Open-ILS/src/sql/Pg/300.schema.staged_search.sql +++ b/Open-ILS/src/sql/Pg/300.schema.staged_search.sql @@ -21,6 +21,36 @@ BEGIN; CREATE SCHEMA search; +CREATE OR REPLACE FUNCTION evergreen.pg_statistics (tab TEXT, col TEXT) RETURNS TABLE(element TEXT, frequency INT) AS $$ +BEGIN + RETURN QUERY + SELECT e, + f + FROM (SELECT ROW_NUMBER() OVER (), + (f * 100)::INT AS f + FROM (SELECT UNNEST(most_common_elem_freqs) AS f + FROM pg_stats + WHERE tablename = tab + AND attname = col + )x + ) AS f + JOIN (SELECT ROW_NUMBER() OVER (), + e + FROM (SELECT UNNEST(most_common_elems::text::text[]) AS e + FROM pg_stats + WHERE tablename = tab + AND attname = col + )y + ) AS elems USING (row_number); +END; +$$ LANGUAGE PLPGSQL; + +CREATE FUNCTION evergreen.query_int_wrapper (INT[],TEXT) RETURNS BOOL AS $$ +BEGIN + RETURN $1 @@ $2::query_int; +END; +$$ LANGUAGE PLPGSQL STABLE; + CREATE TABLE search.relevance_adjustment ( id SERIAL PRIMARY KEY, active BOOL NOT NULL DEFAULT TRUE, -- 2.43.2