Re: short-cutting if sum()>constant

From: msi77 <msi77(at)yandex(dot)ru>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: short-cutting if sum()>constant
Date: 2009-12-22 19:15:02
Message-ID: 1751261509302@webmail116.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> Sorry, but i don't know how a CTE can help in this case, can you explain

I mean RECURSIVE CTE. You can check your condition on each iteration and stop execution when condition is false.

Sergey

> msi77 <msi77(at)yandex(dot)ru> wrote:
> > Развернуть
> > Does PG support CTE?
> Since 8.4 yes.
> > Развернуть
> > You can try it.
> Sorry, but i don't know how a CTE can help in this case, can you explain
> that?
> Andreas
>

Здесь спама нет http://mail.yandex.ru/nospam/sign

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Pavel Stehule 2009-12-22 19:47:18 Re: short-cutting if sum()>constant
Previous Message Andreas Kretschmer 2009-12-22 17:30:09 Re: short-cutting if sum()>constant