Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to sql-recursive statements work?

I am trying to understand sql recursive statements, but it is really hard for me. For example:

enter image description here

Thats an exampe I am trying to understand and to write down the output.

Can sb pls explain me how this works, step by step?

greetings and thx in advance

maya

like image 976
maximus Avatar asked Nov 05 '22 04:11

maximus


1 Answers

Also, see here - http://www.postgresql.org/docs/8.4/static/queries-with.html, where the steps of the recursive query evaluation are described.

like image 165
devdigital Avatar answered Nov 07 '22 22:11

devdigital