ora2pg
ora2pg copied to clipboard
Reserverd word year/month not recognised in with
The with part of a query: with data as ( select accumulation_nm, operator_nm, extract (year from t1.start_date) year, extract (month from t1.start_date) month, quantity / 1000 as quantity FROM res_prod_fig_mnth_acc_gas_d t1 )
Get transformed into: with data as ( select accumulation_nm, operator_nm, extract(year FROM t1.start_date) year, extract(month from t1.start_date) month, quantity / 1000 as quantity FROM res_prod_fig_mnth_acc_gas_d t1 )
But both 'year' and 'month' are reserved words and should be quoted as the quoting of reserverd words was enabled in the config.