SELECT DISTINCT EXTRACT( YEAR FROM '2011-11-01'::date + generate_series(0,'2013-01-01'::date - '2011-01-01'::date) ) as "Years" ORDER BY "Years"
Получим результат:
Years ------------------------- 2011 2012 2013