Writing a Foreign Data Wrapper and interested in isolating the WHERE clause to speed up the access of an indexed file on my filesystem. I'm attempting to understand the inner workings of how the data is retrieved so I'm writing code to just handle one case at the moment: WHERE clause on a single column in the foreign 'table'.
SELECT * FROM t WHERE testval = 1
I have this code so far, an implementation of the IterateForeignScan interface.
yet am not familiar with what I need to do to pick apart RestrictInfo in order to gather 'testvar', '=', and '1' separately so I can interpret and pass those through to my file parser.
Am I going about this the correct way or is there another path I should follow?