[odb-users] native query with CTE

[Lisa Fiedler]

Yes I did this already. This does not seem to be the problem.

Apperently a 'Where' is prepended, if the query does not start with 
'SELECT...'

On 15.03.19 09:44, Boris Kolpackov wrote:
> Lisa Fiedler <lfiedler at informatik.uni-leipzig.de> writes:
>
>> db->query<queryAbstractNodes_view>(" WITH nodeTable AS( "
> Can you try removing the leading space in " WITH...", that is:
>
> db->query<queryAbstractNodes_view>("WITH nodeTable AS( "