Re: PostgreSQL sequence within function

Поиск
Список
Период
Сортировка
От Tony Caduto
Тема Re: PostgreSQL sequence within function
Дата
Msg-id 42CB07DC.3040009@amsoftwaredesign.com
обсуждение исходный текст
Ответ на PostgreSQL sequence within function  (Clark Allan <clarka@gmail.com>)
Ответы Re: PostgreSQL sequence within function
Список pgsql-general
Or upgrade your server to 8.x and use dollar quoting.
with dollar quoting all that is a thing of the past.

CREATE FUNCTION sp_slide_create(int4) RETURNS int4 AS
$$
DECLARE
aScriptID ALIAS FOR $1;
seqID int4 := nextval('genseq'); -- no magic needed with dollar qouting :-)
BEGIN

INSERT INTO tblslides (slideid) VALUES (seqID);

RETURN seqID;

END;
$$
LANGUAGE 'plpgsql' VOLATILE


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