Subject Re: [firebird-support] Recursive Relationship on Dictionary Table
Author Thomas Steinmaurer
Hi,

> Hi,
>
>
> Is this list allowed to post SQL queries ou links? Anyway if someone is
> interested and can help me, I did a recent post on SO which has been a
> great challenge to me, although it seems simple at first sight:
>
>
> https://stackoverflow.com/questions/56220744/recursive-relationship-on-dictionary-table

If your question is, if Firebird supports recursive queries via Common
Table Expressions (CTE), then the answer is yes. Since Firebird 2.1.

https://firebirdsql.org/refdocs/langrefupd21-select.html#langrefupd21-select-cte



--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.