Re: View based upon function won't use index on joins - Mailing list pgsql-performance

How about

CREATE OR REPLACE VIEW value_codes_view AS
select * from (
 SELECT value_codes.id_nbr,
      value_codes.id_qfr,
      (ARRAY[val_1_cd_1, ... , val_2_cd_12])[i] as value_code,
      (ARRAY[val_1_amt_1, ... , val_2_amt_12])[i] as value_amount,
   FROM value_codes, generate_series(1,24) i) a
where value_code is not null and value_code != '';
?