Return to DESCR CVS log

Up to [cvs.NetBSD.org] / pkgsrc / databases / postgresql92-datatypes

Annotation of pkgsrc/databases/postgresql92-datatypes/DESCR, Revision 1.5

1.5     ! joerg       1: This package provides the following PostgreSQL modules: btree_gist,
        !             2: citext, hstore, intarray, isn, ltree, lo, uuid-ossp, unaccent.
        !             3:
        !             4: The "btree_gist" module provides GIST operator classes for scalar data types.
1.3       asau        5:
                      6: The "citext" module provides a case-insensitive character string type,
                      7: citext. Essentially, it internally calls lower when comparing values.
                      8: Otherwise, it behaves almost exactly like text.
                      9:
                     10: The "hstore" module implements the "hstore" data type for storing sets
                     11: of key/value pairs within a single PostgreSQL value. This can be useful
                     12: in various scenarios, such as rows with many attributes that are rarely
                     13: examined, or semi-structured data. Keys and values are simply text strings.
                     14:
                     15: The "intarray" module provides a number of useful functions and operators
                     16: for manipulating one-dimensional arrays of integers. There is also support
                     17: for indexed searches using some of the operators.
                     18:
                     19: The "isn" module provides data types for the following international
                     20: product numbering standards: EAN13, UPC, ISBN (books), ISMN (music),
                     21: and ISSN (serials). Numbers are validated on input, and correctly
                     22: hyphenated on output.
                     23:
                     24: The "ltree" module implements a data type ltree for representing
                     25: labels of data stored in a hierarchical tree-like structure.
                     26: Extensive facilities for searching through label trees are provided.
1.1       adam       27:
1.3       asau       28: The "lo" module provides support for managing Large Objects (also called
                     29: LOs or BLOBs). This includes a data type "lo" and a trigger "lo_manage."
1.1       adam       30:
                     31: The "uuid-ossp" module provides functions to generate universally unique
1.3       asau       32: identifiers (UUIDs) using one of several standard algorithms. There are
                     33: also functions to produce certain special UUID constants.
1.1       adam       34:
                     35: "unaccent" is a text search dictionary that removes accents (diacritic signs)
1.3       asau       36: from lexemes. It's a filtering dictionary, which means its output is always
                     37: passed to the next dictionary (if any), unlike the normal behavior of
                     38: dictionaries. This allows accent-insensitive processing for full text search.