[NOVICE] pl/pgsql and returns timestamp type
От | rmit.test2115@gmail.com |
---|---|
Тема | [NOVICE] pl/pgsql and returns timestamp type |
Дата | |
Msg-id | 3D7E1074.7C4B1520@technovell.com обсуждение исходный текст |
Ответы |
Re: [NOVICE] pl/pgsql and returns timestamp type
|
Список | pgsql-novice |
Hi all, I cannot to get this to run... I think I am mistaking some basic concept or I have a big brain-lock . Somebody know whatis the problem to execute this function ? Thanks in advance... --==================================== DROP TABLE test; CREATE TABLE test ( clave numeric(7,0) not null, PRIMARY KEY (clave) ) WITHOUT OIDS; --==================================== DROP FUNCTION f_test(numeric(7,0), numeric(7,0)); CREATE OR REPLACE FUNCTION f_test(numeric(7,0), numeric(7,0)) RETURNS timestamp AS ' DECLARE p_datod ALIAS FOR $1; p_datoh ALIAS FOR $2; -- tdesde timestamp; thasta timestamp; BEGIN tdesde := now(); -- FOR X IN p_datod..p_datoh LOOP INSERT INTO test VALUES (x); END LOOP; -- thasta := now() - tdesde; RETURN thasta; COMMIT; END; ' LANGUAGE 'plpgsql'; --==================================== select f_test(1,9); ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
В списке pgsql-novice по дате отправления: