3 SELECT evergreen.upgrade_deps_block_check('0940', :eg_version);
5 CREATE OR REPLACE FUNCTION evergreen.pg_statistics (tab TEXT, col TEXT) RETURNS TABLE(element TEXT, frequency INT) AS $$
7 -- This query will die on PG < 9.2, but the function can be created. We just won't use it where we can't.
11 FROM (SELECT ROW_NUMBER() OVER (),
13 FROM (SELECT UNNEST(most_common_elem_freqs) AS f
19 JOIN (SELECT ROW_NUMBER() OVER (),
21 FROM (SELECT UNNEST(most_common_elems::text::text[]) AS e
26 ) AS elems USING (row_number);
30 CREATE OR REPLACE FUNCTION evergreen.query_int_wrapper (INT[],TEXT) RETURNS BOOL AS $$
32 RETURN $1 @@ $2::query_int;
34 $$ LANGUAGE PLPGSQL STABLE;