can a function take a column name or is there another solution

I have a table with sampledate, meter1, meter2...etc

I am trying to develop a function or query 

where:

select sampledate, (meter1 - (select meter1 where sampledate = sampledate + interval '1 days')) as consumption from mytable;



Any ideas how to make this work?


Mark King