Return to Answer

##Stored functions

##Calculations

##Spread it out

###Explicit create table in insert statement

Stored functions

Calculations

Spread it out

Explicit create table in insert statement

I have put together a while back a stored function used to insert data into multiple tables in one transaction. Perhaps it will inspire you to write something with that kind of logic, as a model.

I have put together a while back a stored function used to insert data into multiple tables in one transaction. Perhaps it will inspire you to write something with that kind of logic, as a model.

This one comes up constantly in your insert query:

("Selected_Period".da_spread_diff*-1)

Put that one in a variable too... (sorry, data type is unclear, use whatever is appropriate)

period_da_spread_diff INTEGER := SELECT (da_spread_diff*-1) FROM public.darts_calculated_partitioned;

That immensely simplifies your code:

   period_da_spread_diff AS "LMP DA A-B Spread", 
   AVG(period_da_spread_diff) as "LMP DA A-B Spread PL", 
     0.50 AS "Submitted Bid",
    CASE WHEN period_da_spread_diff <=0.50 THEN TRUE ELSE FALSE END AS "Filled",
    CASE WHEN period_da_spread_diff <=0.50 THEN 1 ELSE 0 END AS "Filled %",
    CASE WHEN period_da_spread_diff <=0.50 THEN period_da_spread_diff END AS "Price Filled At",