Skip to content
Sections
>> Trisquel >> Packages >> nabia >> database >> postgresql-12-prefix
nabia  ]
[ Source: prefix  ]

Package: postgresql-12-prefix (1.2.9-2)

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-12-prefix

  • depends
  • recommends
  • suggests
  • dep: libc6 (>= 2.14) [amd64]
    GNU C Library: Shared libraries
    also a virtual package provided by libc6-udeb
    dep: libc6 (>= 2.4) [armhf]
  • dep: postgresql-12
    object-relational SQL database, version 12 server

Download postgresql-12-prefix

Download for all available architectures
Architecture Package Size Installed Size Files
amd64 42.3 kB121 kB [list of files]
armhf 38.7 kB105 kB [list of files]