11 lines
512 B
SQL
11 lines
512 B
SQL
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));;
|