S
S
Sergey Beloventsev2017-09-23 08:19:25
PostgreSQL
Sergey Beloventsev, 2017-09-23 08:19:25

What's wrong with querying trees?

here is the request

SELECT last_name FROM "user" WHERE "tree_path" ~ '1.2.3* {1,5}';

I get such an error
ERROR:  syntax error at position 7
LINE 1: SELECT last_name FROM "user" WHERE "tree_path" ~ '2.383.* {1...
                                                          ^

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question