Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 192814

Acronym for Common Table Expression. Temporary, reusable subquery that may be recursive.

0
votes
It does not seem possible to get control on how the recursion happens in CTE. One solution to disentangle results is to add info on the parent query and build a 'path' for each result. As shown in …
answered Oct 15 by coolnodje
0
votes
1answer
I have this query used on Postgres to return place administrative levels. WITH RECURSIVE hierarchy(name, pinyin, level) AS ( SELECT p.name, p.pinyin, p.level, p.upper_place_object_id_fk from …
asked Oct 10 by coolnodje