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 по дате отправления: