PostgreSQL IP address: Search the right result by inet data?, PostgreSQL

PostgreSQL IP address: Search the right result by inet data?

Language: Layout:


absolute service time: 0,4 sec

edit mode | history

  
addr
is like '1111:0%'
is within '1111::/20'

1
1111::5/128
False
True

2
1111:1:101:a:2:3:4:5/128
False
True

3
1111:11:101:a:2:3:4:5/128
False
True

4
1111:111:101:a:2:3:4:5/128
False
True

5
1111:1111:101:a:2:3:4:5/128
False
False

6
1111:f111:101::5/128
False
False

λ

                                      .NET NoSQL database for rapid development