My first PL/pgSQL function

Поиск
Список
Период
Сортировка
От Didier Gasser-Morlay
Тема My first PL/pgSQL function
Дата
Msg-id 608b66ce0911180845o72bdddccj8b2b9d10c99c4baa@mail.gmail.com
обсуждение исходный текст
Список pgsql-novice
I am by no means an expert in PL/SQL but your function seems ok to me;

your currcal is fine (if you used nextval as someone suggested, you'd get the next value, which is not what you intend, creating user<->groups links.

That said, I ddo not know if doing and insert then asking for curval is atomic or if you could get a wrong value if someone else creates a user at theat moment;

To be on the safe side, I always use insert ... returning syntax  this way I know that I am getting the same value as the one inserted.

Just my 0.02EUR

Didier


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

Предыдущее
От: "A. Kretschmer"
Дата:
Сообщение: Re: My second PL/pgSQL function - minor problem
Следующее
От: Mladen Gogala
Дата:
Сообщение: Introduction