I am trying to use the EXTRACT function in pl/pgsql and running into a problem.
This is the command:
SELECT EXTRACT(EPOCH FROM TIMESTAMP variable_name) INTO Temp;
The variable_name is of type text (I've also tried it as type timestamp), but the parser breaks when it attempts to perform this function. It works great when I substitute the variable_name with '2004-1-10 00:00:00' , however, when I use a variable, it doesn't.
Any one have any ideas on how I can get variable substitution to work in my function using EXTRACT?
