sintax???

Поиск
Список
Период
Сортировка
От Alfonso Peniche
Тема sintax???
Дата
Msg-id 3A79FD95.E637213F@iteso.mx
обсуждение исходный текст
Ответы Re: sintax???  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список 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?


В списке pgsql-general по дате отправления:

Предыдущее
От: Alvar Freude
Дата:
Сообщение: Re: Is Oracle really so much faster
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: sintax???