Group by a regular expression in a postgres query, PostgreSQL

Group by a regular expression in a postgres query

Language: Layout:


absolute service time: 0,85 sec

fork mode | history

  
regexp_replace
count

1
https://test.com/banana/{x}
2

2
https://test.com/post/{x}/date
1

3
http://test.com/post/{x}/date
1

4
https://test.com/user/{x}/info
2

5
https://test.com/test/{x}/info
2

6
https://test.com/grape/
1

7
https://test.com/post/
1

λ

                                      .NET NoSQL database for rapid development