Re: generate_series woes

From: Volkan YAZICI <yazicivo(at)ttmail(dot)com>
To: depesz(at)depesz(dot)com
Cc: Harald Fuchs <hari(dot)fuchs(at)googlemail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: generate_series woes
Date: 2008-04-16 12:37:22
Message-ID: 87skxm6kn1.fsf@alamut.mobiliz.com.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hubert depesz lubaczewski <depesz(at)depesz(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Julio Cesar Sánchez González 2008-04-16 12:47:38 Re: Master-master replication with PostgreSQL
Previous Message hubert depesz lubaczewski 2008-04-16 12:35:15 Re: generate_series woes