December 16th, 2011 by depesz | Tags: cte, postgresql, recursive, tree, with recursive | 2 comments »
I got asked on irc to show some examples how to use recursive CTE. Apparently my previous post wasn't good enough :) I think that most of the users will use recursive cte to deal with trees I decided to show ...
March 23rd, 2009 by depesz | Tags: adjacency list, children, plpgsql, postgresql, tree | 4 comments »
So, you have a table which looks like this: # \d test Table "public.test" ...
Quick note in polish: jeśli znasz moje poprzednie posty nt. drzew, to ten możesz sobie pewnie odpuścić. będzie zawierał jedynie opis implementacji zbliżony do tego co już jest dostępne. OK, back to English (or at least my version of English). Finding a ...
