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 >> query has a GROUP BY. >> >> Why is it not allowed? > Because standard prohibits any kind of aggregates in recursive CTE > members. > Could you point me where is this described? I don't found it.
Adriano ------------------------------------------------------------------------------ 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
