Re: generate_series woes

On Wed, Apr 16, 2008 at 8:37 AM, Volkan YAZICI <yazicivo@ttmail.com> wrote:
> hubert depesz lubaczewski <depesz@depesz.com> writes:
>  > i think it would be better off not to limit some functionality for
>  > builtin functions. it would be much nicer to have the ability to hint
>  > planer about rowcount from function *in* the sql.
>  >
>  > something like:
>  >
>  > select i from generate_series(1,10) {hint:10} as i;
>  >
>  > i'm not proposiung syntax. i'm suggesting the functionality.
>
>  I'm strongly declined for such non-SQL compliant solutions. I'd be
>  appreciated if hackers can solve the problem internally, without bugging
>  SQL syntax.

maybe -- just an idle thought -- the 'ROWS' clause of create function
could be expanded to take a simple expression based on the input
parameters.

merlin