On Fri, Mar 19, 2004 at 07:44:25 -0700,
Derrick Betts <Derrick@Blue-Axis.com> wrote:
> 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
performthis function. It works great when I substitute the variable_name with '2004-1-10 00:00:00' , however, when I
usea variable, it doesn't.
>
> Any one have any ideas on how I can get variable substitution to work in my function using EXTRACT?
I don't think typename variable is a valid operation. You would need to use
CAST or :: to do a typecast. Probably you should just leave out "TIMESTAMP"
from your example.