PostgREST / postgrest

REST API for any Postgres database
https://postgrest.org
MIT License
22.65k stars 1k forks source link

Calculate math with addition, submission or calculated field #3519

Closed maurerle closed 1 month ago

maurerle commented 1 month ago

Description of issue

I was wondering what the best way of creating a query like:

select temp_air-273.15 as temp_celsius from weather would be.

select wind_meridional+wind_zonal as temp_celsius from weather

If I understood correctly, there is currently no way to execute the above query using postgREST? In this case I would like to vote to add a way to apply mathematical operations in the select column :)

I did not find a similar issue to this yet :)