Re: generate_series woes

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.


Regards.