23,888 reputation
13671
bio website
location Vienna, Austria
age 94
visits member for 3 years, 2 months
seen 19 mins ago

Freelance database expert.


12m
comment How can I create a bool column for a view based on the result of a statement?
@Bryan: Oh, because my query was missing the last line. Sorry, fixed.
13m
revised How can I create a bool column for a view based on the result of a statement?
missing group by
5h
comment Recursive CTE to find unique slug
@user4150760: Good question. There are elegant solutions. Should be another question. But I added another answer anyway.
5h
revised Recursive CTE to find unique slug
add another answer
5h
reviewed Approve Recursive CTE to find unique slug
7h
comment How can I create a bool column for a view based on the result of a statement?
@Bryan: That's a different query, typically more expensive with big tables and/or many users per group.
7h
revised How can I create a bool column for a view based on the result of a statement?
add solution
7h
revised How can I create a bool column for a view based on the result of a statement?
added 30 characters in body
7h
comment Get products of category plus all child categories till leave nodes
The diagram is nice, but you still need to provide your table definitions and your version of Postgres, and some explanation what's what in the diagram.
7h
revised How can I create a bool column for a view based on the result of a statement?
add link, clarify
8h
revised How can I create a bool column for a view based on the result of a statement?
edited tags
8h
answered How can I create a bool column for a view based on the result of a statement?
13h
comment SELECT query with DISTINCT on a table-structure for graphs is very slow
So do you have your answer?
13h
revised SELECT query with DISTINCT on a table-structure for graphs is very slow
typos
13h
revised Possible reasons for irregularly high query execution time?
edited tags
15h
awarded  Guru
16h
revised Recursive CTE to find unique slug
fix title
1d
revised Recursive CTE to find unique slug
add notes concerning race condition and ambiguity
1d
comment Recursive CTE to find unique slug
@user4150760: The ambiguity between the basic slug name and slug name plus appended suffix is built into your specifications. It's not something my solution added. You have to disambiguate yourself. For instance: use a character otherwise disallowed before the suffix.
1d
revised Recursive CTE to find unique slug
edited tags