[GENERAL] plpgsql extract epoch problem

[Darren Ferguson]

Hey all

I am trying to extract the epoch from a timestamp variable in plpgsql.
The function is as follows:
create or replace function test() returns integer as '
declare
 _test timestamp with time zone;
 _f integer;
begin
 _test := current_timestamp;
 _f := extract(epoch from timestamp _test);
 return _f;
end;' language 'plpgsql';
Any ideas why this will not work????

The error is as follows:
pts=> select test();
WARNING:  Error occurred while executing PL/pgSQL function test
WARNING:  line 6 at assignment
ERROR:  parser: parse error at or near "$1" at character 40
And that is the _test variable

Any help greatly apprechiated
Darren
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly