Subject | Re: [firebird-support] Recursive Relationship on Dictionary Table |
---|---|
Author | Thomas Steinmaurer |
Post date | 2019-05-23T15:44:45Z |
Hi,
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.
> Hi,If your question is, if Firebird supports recursive queries via Common
>
>
> 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
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.