returning a record from PL/pgSQL

Поиск
Список
Период
Сортировка
От KÖPFERL Robert
Тема returning a record from PL/pgSQL
Дата
Msg-id ED4E30DD9C43D5118DFB00508BBBA76EB1657C@neptun.sonorys.at
обсуждение исходный текст
Ответы Re: returning a record from PL/pgSQL  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-sql
I just tried hard to return
a single record fromout a plpgsql-function. While the (otherwise excelent)
documentation didn't give me an answer, I found out that this works:
       select into ret false, balance, balance;       return ret;

while ret is a composite type.

This construction however tastes not good to me. Is there a nicer way?

An example for PL/pgSQL which returns not just a scalar but also a composite
type should be added to the documentation. i.e. as second part of the RETURN
statement.


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

Предыдущее
От: "Andrei Bintintan"
Дата:
Сообщение: Re: [PERFORM] OFFSET impact on Performance???
Следующее
От: "Joel Fradkin"
Дата:
Сообщение: Re: still having pg_user error