Plpgsql Question
От | Oxeye |
---|---|
Тема | Plpgsql Question |
Дата | |
Msg-id | 003301c1d73f$bac32ff0$05a8a8c0@oxeye обсуждение исходный текст |
Ответ на | Performance Tuning Document? (Matthew Kirkwood <matthew@hairy.beasts.org>) |
Ответы |
Re: Plpgsql Question
|
Список | pgsql-general |
Hello, I'm new to Postgresql and plpgslq. I wrote a plpgsql to return epoch time from a table, but had problem running it. The error returned: NOTICE: Error occurred while executing PL/pgSQL function sleeptime NOTICE: line 10 at assignment ERROR: Bad timestamp external representation 'rec_runtime.runtime' My plpgsql function: create function sleeptime () returns float as ' declare rec_runtime record; ret_sleepsecs float; begin select into rec_runtime runtime from mon_nextrun order by runtime limit 1; if rec_runtime.runtime is null then return 60; end if; ret_sleepsecs := extract (epoch from timestamp ''rec_runtime.runtime'') as float; return ret_sleepsecs; end; ' language 'plpgsql'; What is the correct syntax for extract function in the assignment statement? Thanks in advance. -CT
В списке pgsql-general по дате отправления: