Re: short-cutting if sum()>constant - Mailing list pgsql-sql

From msi77
Subject Re: short-cutting if sum()>constant
Date
Msg-id 1751261509302@webmail116.yandex.ru
Whole thread Raw
In response to Re: short-cutting if sum()>constant  (Andreas Kretschmer <akretschmer@spamfence.net>)
List 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@yandex.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


pgsql-sql by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: short-cutting if sum()>constant
Next
From: Pavel Stehule
Date:
Subject: Re: short-cutting if sum()>constant