Hi Adriano,
Am 04.12.2011 19:36, schrieb Adriano dos Santos Fernandes:
On 30-11-2011 23:36, Adriano dos Santos Fernandes wrote:
On 16-11-2011 22:39, Frank Ingermann wrote:
Hi all,
i'm trying to combine the new Window functions in Fb3 with
recursive CTEs to get a _defined_ ordering of the
On 30-11-2011 23:36, Adriano dos Santos Fernandes wrote:
On 16-11-2011 22:39, Frank Ingermann wrote:
Hi all,
i'm trying to combine the new Window functions in Fb3 with
recursive CTEs to get a _defined_ ordering of the recursive
child records in the result set.
The recursive problem is
On 16-11-2011 22:39, Frank Ingermann wrote:
Hi all,
i'm trying to combine the new Window functions in Fb3 with
recursive CTEs to get a _defined_ ordering of the recursive
child records in the result set.
The recursive problem is fixed, in fact it was a problem of window
functions with
On 21/11/2011 16:45, Frank Ingermann wrote:
Hi,
Am 19.11.2011 01:04, schrieb Vlad Khorsun:
Because standard prohibits any kind of aggregates in recursive CTE
members.
So this would mean option b) is correct:
b) [ ] window functions are not supposed to work in the child select
Hi Adriano,
Am 21.11.2011 20:04, schrieb Adriano dos Santos Fernandes:
On 21/11/2011 16:45, Frank Ingermann wrote:
So this would mean option b) is correct:
b) [ ] window functions are not supposed to work in the child select
part of recursive CTEs
- since Window functions belong
On 18/11/2011 05:38, Vlad Khorsun wrote:
On 16-11-2011 22:39, Frank Ingermann wrote:
...but it leads to an endless loop/recursion (using latest Fb3 beta)
:-(
Before decide what to do, I'd like to hear Vlad about the error
isc_dsql_cte_wrong_clause, which, for example, happens if a recursive
17.11.2011 4:39, Frank Ingermann wrote:
a) [ ] file it as a bug - this _should_ work!
This would get my vote, as it works fine (and returns rows in the
expected order) in PGSQL.
Dmitry
--
All the data continuously
On 16-11-2011 22:39, Frank Ingermann wrote:
...but it leads to an endless loop/recursion (using latest Fb3 beta)
:-(
Before decide what to do, I'd like to hear Vlad about the error
isc_dsql_cte_wrong_clause, which, for example, happens if a recursive
query has a GROUP BY.
Why is it