Hey folks, I'm trying to write a plpgsql function which returns a subset of a table. For example a table that has columns A, B, C. I am trying to return the results of a SELECT A, B WHERE C = 'someconstant'
Second to that I'm wanting to add a row to the result that doesn't exist in the databast as part of that return value. Is this possible?