pl/pgsql and returns timestamp type

From: Terry Yapt <yapt(at)technovell(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: pl/pgsql and returns timestamp type
Date: 2002-09-10 15:32:04
Message-ID: 3D7E1074.7C4B1520@technovell.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 what is 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);

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Berkus 2002-09-10 15:34:23 Re: Problems with substring
Previous Message Ernesto Jardim 2002-09-10 14:31:03 login problem