firebird-support - Re: [firebird-support] Sort hierarchical data

Subject	Re: [firebird-support] Sort hierarchical data
Author	Walter R. Ojeda Valiente
Post date	2015-10-30T15:55:38Z

If you can read Spanish, there are several articles about that topic:

https://firebird21.wordpress.com/2013/10/10/stored-procedures-recursivos/

https://firebird21.wordpress.com/2015/08/22/usando-recursividad-con-cte/

https://firebird21.wordpress.com/2015/08/27/ejemplo-de-recursion-1/

https://firebird21.wordpress.com/2015/08/28/ejemplo-de-recursion-2/

https://firebird21.wordpress.com/2015/08/29/ejemplo-de-recursion-3/

https://firebird21.wordpress.com/2015/08/30/ejemplo-de-recursion-4-actualizando-filas-recursivamente/

https://firebird21.wordpress.com/2015/08/31/ejemplo-de-recursion-5-saldos-acumulados/

https://firebird21.wordpress.com/2015/09/05/ejemplo-de-recursion-6-repitiendo-las-filas/

Greetings.

Walter.

On Wed, Oct 21, 2015 at 6:37 AM, Josef.Gschwendtner@... [firebird-support] <firebird-support@yahoogroups.com> wrote:

Hi,
I have a table with hierarchical
data.
There is a numeric sortfield where the user sets the sort-order of the children of a particular parent (values from 1 to n für each parent).

How can I write a recursive query which selects the whole tree and honors these sortnumbers.

TIA,
Josef