hubert depesz lubaczewski <depesz@xxxxxxxxxx> 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.