-- Function: test.date_part(text, anyarray)
CREATE OR REPLACE FUNCTION test.date_part(part text,from_array anyarray)
  RETURNS integer[] --for btree_gist
AS
$BODY$
	SELECT ARRAY( 
		SELECT date_part(part, unnest(from_array))::integer u	
		) foo
	;	
$BODY$
  LANGUAGE sql IMMUTABLE SECURITY DEFINER
  COST 100;
COMMENT ON FUNCTION test.date_part(text, anyarray) IS 'Возвращает массив частей массива timestamp-oв или date-ов';
---------------------------
CREATE INDEX 
  ON test.test_20140201
  USING gist
  ((test.date_part('year',dates_oper)),(test.date_part('month',dates_oper)),(test.date_part('day',dates_oper)),(test.date_part('hour',dates_oper)));
---------------------
SELECT * FROm test.test_20140201
WHERE 
	 ( test.date_part('year',dates_oper) )&& ARRAY[2014]
	AND	( (( test.date_part('month',dates_oper) )&& ARRAY[2]
			AND  ( test.date_part('day',dates_oper) )&& ARRAY[28,29,30,31])
			)
		OR ( ( test.date_part('month',dates_oper) )&& ARRAY[3]
		AND  ( test.date_part('day',dates_oper) )&& ARRAY[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17])	
	--AND  ( test.date_part('hour',dates_oper) )&& ARRAY[..............]

	AND 
	'[2014-02-28 00:00:00,2014-03-17 00:00:00)'::tsrange @> any(dates_oper)
------------------------------------------------------
Bitmap Heap Scan on test_20140201  (cost=9.83..15.12 rows=1 width=162) (actual time=0.992..3.846 rows=47 loops=1)
  Recheck Cond: (((test.date_part('year'::text, dates_oper) && '{2014}'::integer[]) AND (test.date_part('month'::text, dates_oper) && '{2}'::integer[]) AND (test.date_part('day'::text, dates_oper) && '{28,29,30,31}'::integer[])) OR ((test.date_part('month'::text, dates_oper) && '{3}'::integer[]) AND (test.date_part('day'::text, dates_oper) && '{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17}'::integer[])))
  Filter: (((test.date_part('year'::text, dates_oper) && '{2014}'::integer[]) AND (test.date_part('month'::text, dates_oper) && '{2}'::integer[]) AND (test.date_part('day'::text, dates_oper) && '{28,29,30,31}'::integer[])) OR ((test.date_part('month'::text, dates_oper) && '{3}'::integer[]) AND (test.date_part('day'::text, dates_oper) && '{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17}'::integer[]) AND ('["2014-02-28 00:00:00","2014-03-17 00:00:00")'::tsrange @> ANY (dates_oper))))
  ->  BitmapOr  (cost=9.83..9.83 rows=1 width=0) (actual time=0.312..0.312 rows=0 loops=1)
        ->  Bitmap Index Scan on test_20140201_date_part_date_part1_date_part2_date_part3_idx  (cost=0.00..5.04 rows=1 width=0) (actual time=0.065..0.065 rows=0 loops=1)
              Index Cond: ((test.date_part('year'::text, dates_oper) && '{2014}'::integer[]) AND (test.date_part('month'::text, dates_oper) && '{2}'::integer[]) AND (test.date_part('day'::text, dates_oper) && '{28,29,30,31}'::integer[]))
        ->  Bitmap Index Scan on test_20140201_date_part_date_part1_date_part2_date_part3_idx  (cost=0.00..4.79 rows=1 width=0) (actual time=0.246..0.246 rows=47 loops=1)
              Index Cond: ((test.date_part('month'::text, dates_oper) && '{3}'::integer[]) AND (test.date_part('day'::text, dates_oper) && '{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17}'::integer[]))
Total runtime: 3.935 ms
---------------------------------------------------
SELECT * FROm test.test_20140201
WHERE 	
	'[2014-02-28 00:00:00,2014-03-17 00:00:00)'::tsrange @> any(dates_oper);
-----------------------------------------------------
Seq Scan on test_20140201  (cost=0.00..4703.06 rows=4915 width=162) (actual time=18.144..55.262 rows=47 loops=1)
  Filter: ('["2014-02-28 00:00:00","2014-03-17 00:00:00")'::tsrange @> ANY (dates_oper))
  Rows Removed by Filter: 100489
Total runtime: 55.406 ms
------------------------------------------------------