blob: 95a8e37d4887f69235f26a6758441f2114e4cc4c (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
|
Prefix matching is both very common and important in telephony applications,
where call routing and costs depend on matching caller/callee phone number
to an operator prefix.
Let's say the prefixes table is called prefixes, a typical query will try to
match a phone number to the longest prefix in the table:
SELECT *
FROM prefixes
WHERE prefix @> '0123456789'
ORDER BY length(prefix) DESC LIMIT 1;
|
