Re: generate_series woes - Mailing list pgsql-general

From Volkan YAZICI
Subject Re: generate_series woes
Date
Msg-id 87skxm6kn1.fsf@alamut.mobiliz.com.tr
Whole thread Raw
In response to Re: generate_series woes  (hubert depesz lubaczewski <depesz@depesz.com>)
Responses Re: generate_series woes  (hubert depesz lubaczewski <depesz@depesz.com>)
Re: generate_series woes  ("Merlin Moncure" <mmoncure@gmail.com>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: generate_series woes
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: generate_series woes