plpgsql extract epoch problem

Поиск
Список
Период
Сортировка
От Darren Ferguson
Тема plpgsql extract epoch problem
Дата
Msg-id 3F96B54E.9050801@crystalballinc.com
обсуждение исходный текст
Ответы Re: plpgsql extract epoch problem
Re: plpgsql extract epoch problem
Список pgsql-general
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


В списке pgsql-general по дате отправления:

Предыдущее
От: Andreas Fromm
Дата:
Сообщение: Re: poor cpu utilization on dual cpu box
Следующее
От: Darren Ferguson
Дата:
Сообщение: Re: plpgsql extract epoch problem