> 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 not allowed?
Because standard prohibits any kind of aggregates in recursive CTE members.
Didn't looked for window functions but i don't think its usage is disabled too.
Regards,
Vlad
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure
contains a definitive record of customers, application performance,
security threats, fraudulent activity, and more. Splunk takes this
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
