CREATE OR REPLACE VIEW public.vw_utility_price_curve_prices AS SELECT pp.id AS "intPriceCurveId", ppv.price_date AS "dtmPriceDate", (ppv.high_price)::numeric(18,6) AS "dblHighPrice", (ppv.low_price)::numeric(18,6) AS "dblLowPrice", (ppv.open_price)::numeric(18,6) AS "dblOpenPrice", (ppv.price_value)::numeric(18,6) AS "dblPriceValue" FROM (price_price pp LEFT JOIN price_price_value ppv ON (((pp.id = ppv.price) AND (ppv.active = true)))) WHERE ((1 = 1) AND (pp.active = true));;