Re: SELECT Question - Mailing list pgsql-general

From Joe Conway
Subject Re: SELECT Question
Date
Msg-id 3FBD0030.6020108@joeconway.com
Whole thread Raw
In response to Re: SELECT Question  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: SELECT Question
Next
From: Tom Lane
Date:
Subject: Re: tsearch2 installation