Re: plpgsql extract epoch problem

Sorry found the answer
I was taking the docs to literal

It should be extract(epoch from _test)

Sorry for the email
Darren

Darren Ferguson wrote:

> 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 majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly