Re: [GENERAL] generate_series woes

2008-04-16 Thread Sam Mason
On Wed, Apr 16, 2008 at 09:01:10AM -0400, Merlin Moncure wrote: > On Wed, Apr 16, 2008 at 8:37 AM, Volkan YAZICI <[EMAIL PROTECTED]> wrote: > > hubert depesz lubaczewski <[EMAIL PROTECTED]> writes: > > > select i from generate_series(1,10) {hint:10} as i; > > > > > > i'm not proposiung syntax. i'm

Re: [GENERAL] generate_series woes

2008-04-16 Thread Merlin Moncure
On Wed, Apr 16, 2008 at 8:37 AM, Volkan YAZICI <[EMAIL PROTECTED]> wrote: > hubert depesz lubaczewski <[EMAIL PROTECTED]> 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 rowc

Re: [GENERAL] generate_series woes

2008-04-16 Thread hubert depesz lubaczewski
On Wed, Apr 16, 2008 at 03:37:22PM +0300, Volkan YAZICI wrote: > 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. for generate_series - sure. but i have functions which change (in a known way

Re: [GENERAL] generate_series woes

2008-04-16 Thread Volkan YAZICI
hubert depesz lubaczewski <[EMAIL PROTECTED]> 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_serie

Re: [GENERAL] generate_series woes

2008-04-16 Thread hubert depesz lubaczewski
On Mon, Apr 14, 2008 at 11:21:58AM +0200, Harald Fuchs wrote: > I think there's something sub-optimal with generate_series. > In the following, "documents" is a table with more than 12 rows, > vacuumed and analyzed before the queries. > Since generate_series is a builtin function, can't it tell

Re: [GENERAL] generate_series woes

2008-04-16 Thread Harald Fuchs
In article <[EMAIL PROTECTED]>, "Merlin Moncure" <[EMAIL PROTECTED]> writes: > On Mon, Apr 14, 2008 at 5:21 AM, Harald Fuchs <[EMAIL PROTECTED]> wrote: >> I think there's something sub-optimal with generate_series. >> In the following, "documents" is a table with more than 12 rows, >> vacuumed

Re: [GENERAL] generate_series woes

2008-04-15 Thread Merlin Moncure
On Mon, Apr 14, 2008 at 5:21 AM, Harald Fuchs <[EMAIL PROTECTED]> wrote: > I think there's something sub-optimal with generate_series. > In the following, "documents" is a table with more than 12 rows, > vacuumed and analyzed before the queries. everything is working exactly as intended. wh