Re: returning parameters from function

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: returning parameters from function
Дата
Msg-id 20061212105533.GC28714@svana.org
обсуждение исходный текст
Ответ на returning parameters from function  (Rikard Pavelic <rikard.pavelic@zg.htnet.hr>)
Ответы Re: returning parameters from function  ("Shoaib Mir" <shoaibmir@gmail.com>)
Re: returning parameters from function  (Rikard Pavelic <rikard.pavelic@zg.htnet.hr>)
Список pgsql-general
On Tue, Dec 12, 2006 at 10:30:07AM +0100, Rikard Pavelic wrote:
> Hi!
>
> Is there any plan to add implicit declaration of returning parameters
> for functions?
> Something like:
> create function list(in a int) returns setof implicit record as

<snip>

Just "setof record" will do. As for the implicit declaration of
variable names, that's harder. I don't know if you can do that without
making things very ambiguous.

> One other feature that I miss, but no so much is:
> storing the entire function, not just the body
> (because of this pg cant remember exactly how I wrote the
> function, and if there are many parameters inside I get a looong first line)

You should get out what you put in, but it won't remember spacing
outside the function body because the lexer eats that.

I have a file with the function as I want it and edit that. That way I
can have the function exactly how I like it.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Вложения

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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Metadata from NEW and OLD constructs?
Следующее
От: "Shoaib Mir"
Дата:
Сообщение: Re: returning parameters from function