all options
[  trixie  ] [  sid  ]
[ Source: prefix  ]

Package: postgresql-17-prefix (1.2.10-3 and others)

Links for postgresql-17-prefix

Screenshot

Debian Resources:

Download Source Package prefix:

Maintainers:

Similar packages:

Prefix Range module for PostgreSQL

This PostgreSQL module provides the prefix_range datatype, allowing to index searches such as finding the longest prefix matching a telephone number, having prefixes in a table and telephone number as a parameter: 

 select * from prefixes where prefix @> '0100091234';

The prefix column has to be of type prefix_range, and any text field can get indexed by the provided GiST opclass.

Other Packages Related to postgresql-17-prefix

  • depends
  • recommends
  • suggests
  • enhances

Download postgresql-17-prefix

Download for all available architectures
Architecture Version Package Size Installed Size Files
alpha (unofficial port) 1.2.10-3 20.0 kB104.0 kB [list of files]
amd64 1.2.10-3+b1 43.0 kB122.0 kB [list of files]
arm64 1.2.10-3 41.8 kB149.0 kB [list of files]
loong64 (unofficial port) 1.2.10-3 19.6 kB71.0 kB [list of files]
mips64el 1.2.10-3 40.3 kB151.0 kB [list of files]
ppc64 (unofficial port) 1.2.10-3 44.0 kB151.0 kB [list of files]
ppc64el 1.2.10-3 43.7 kB151.0 kB [list of files]
riscv64 1.2.10-3 19.2 kB63.0 kB [list of files]
s390x 1.2.10-3 43.0 kB117.0 kB [list of files]
sparc64 (unofficial port) 1.2.10-3 18.2 kB1,064.0 kB [list of files]