From: | Alfonso Peniche <alfonso(at)iteso(dot)mx> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | sintax??? |
Date: | 2001-02-02 00:21:41 |
Message-ID: | 3A79FD95.E637213F@iteso.mx |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have the following:
CREATE FUNCTION RegistrarConexion(char(8),char(16),char(20))
RETURNS integer
AS '
DECLARE ret integer;
BEGIN
INSERT INTO BitacoraConexion(username, IPmaquina,
nombremaquina, conexion)
VALUES ($1, $2, $3, CURRENT_TIMESTAMP);
SELECT INTO ret
currval('bitacoraconex_idbitacoracon_seq');
RETURN ret;
END;'
LANGUAGE 'plpgsql';
and if I execute this file I get the following error:
psql:SPRegConex.sql:20: ERROR: parser: parse error at or near
"bitacoraconex_idbitacoracon_seq"
I asume it's due to a sintax error having to do with "currval", but I
can't find what the proper sintax would be for 'plpgsql' for getting the
last sequence value assigned (I even tried
select currval('bitacoraconex_idbitacoracon_seq') as ret
with equal result).
Can someone help me out here??????
Thanx
P.S. Is there a manual for plpgsql sintax, instructions, functions....
somewhere?
From | Date | Subject | |
---|---|---|---|
Next Message | <No Name> | 2001-02-02 00:59:16 | Foreign Keys |
Previous Message | Brice Ruth | 2001-02-01 22:57:44 | SQL Join - MySQL/PostgreSQL difference? |