Re: SELECT Question
От | Joe Conway |
---|---|
Тема | Re: SELECT Question |
Дата | |
Msg-id | 3FBD0030.6020108@joeconway.com обсуждение исходный текст |
Ответ на | Re: SELECT Question (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-general |
Tom Lane wrote: > Joe Conway <mail@joeconway.com> writes: >>CREATE OR REPLACE FUNCTION test(int,int) RETURNS SETOF int AS ' >>BEGIN >> FOR i IN $1..$2 LOOP >> RETURN NEXT i; >> END LOOP; >> RETURN; >>END; >>' LANGUAGE 'plpgsql' STRICT IMMUTABLE; > > I was thinking of proposing that we provide something just about like > that as a standard function (written in C, not in plpgsql, so that it > would be available whether or not you'd installed plpgsql). There are > some places in the information_schema that desperately need it --- > right now, the value of FUNC_MAX_ARGS is effectively hard-wired into > some of the information_schema views, which means they are broken if > one changes that #define. We could fix this if we had a function like > the above and exported FUNC_MAX_ARGS as a read-only GUC variable. I've been really busy on other-than-postgres stuff lately, but I'm planning to carve out time next week to start doing some 7.5 development. I'll take this one if you want. Joe
В списке pgsql-general по дате отправления: