Generic Method to find the tuples used for computation in Postgres?
- by Rahul
If I have a table
col1 | name | pay
------+------------------+------
1 | Steve Jobs | 1006
2 | Mike Markkula | 1007
3 | Mike Scott | 1978
4 | John Sculley | 1983
5 | Michael Spindler | 1653
The user executes a sum query which sums the pay of people getting paid more than $1500. Is there a way…