select * from depesz;

couple of times is was brought to attention of #postgresql channel - how to find longest prefix.

case: you have phone number, and you want to find which carrier it is bound to.

there are at least 3 ways of finding it, and i decided to take a look at which is fastest.