diff options
-rw-r--r-- | databases/postgresql90-datatypes/DESCR | 43 | ||||
-rw-r--r-- | databases/postgresql90-datatypes/Makefile | 32 | ||||
-rw-r--r-- | databases/postgresql90-datatypes/PLIST | 26 |
3 files changed, 101 insertions, 0 deletions
diff --git a/databases/postgresql90-datatypes/DESCR b/databases/postgresql90-datatypes/DESCR new file mode 100644 index 00000000000..0fd1fb2d6cd --- /dev/null +++ b/databases/postgresql90-datatypes/DESCR @@ -0,0 +1,43 @@ +This package provides the following PostgreSQL modules: + - citext + - hstore + - intarray + - isn + - ltree + - lo + - uuid-ossp + - unaccent + +The "citext" module provides a case-insensitive character string type, +citext. Essentially, it internally calls lower when comparing values. +Otherwise, it behaves almost exactly like text. + +The "hstore" module implements the "hstore" data type for storing sets +of key/value pairs within a single PostgreSQL value. This can be useful +in various scenarios, such as rows with many attributes that are rarely +examined, or semi-structured data. Keys and values are simply text strings. + +The "intarray" module provides a number of useful functions and operators +for manipulating one-dimensional arrays of integers. There is also support +for indexed searches using some of the operators. + +The "isn" module provides data types for the following international +product numbering standards: EAN13, UPC, ISBN (books), ISMN (music), +and ISSN (serials). Numbers are validated on input, and correctly +hyphenated on output. + +The "ltree" module implements a data type ltree for representing +labels of data stored in a hierarchical tree-like structure. +Extensive facilities for searching through label trees are provided. + +The "lo" module provides support for managing Large Objects (also called +LOs or BLOBs). This includes a data type "lo" and a trigger "lo_manage." + +The "uuid-ossp" module provides functions to generate universally unique +identifiers (UUIDs) using one of several standard algorithms. There are +also functions to produce certain special UUID constants. + +"unaccent" is a text search dictionary that removes accents (diacritic signs) +from lexemes. It's a filtering dictionary, which means its output is always +passed to the next dictionary (if any), unlike the normal behavior of +dictionaries. This allows accent-insensitive processing for full text search. diff --git a/databases/postgresql90-datatypes/Makefile b/databases/postgresql90-datatypes/Makefile new file mode 100644 index 00000000000..01f758c0dd9 --- /dev/null +++ b/databases/postgresql90-datatypes/Makefile @@ -0,0 +1,32 @@ +# $NetBSD: Makefile,v 1.1.1.1 2010/12/11 23:01:51 asau Exp $ + +PKGNAME= postgresql90-datatypes-${BASE_VERS} +COMMENT= PostgreSQL data types support modules + +PKG_DESTDIR_SUPPORT= user-destdir + +DEPENDS+= postgresql90-server>=${BASE_VERS}:../../databases/postgresql90-server + +.include "../../databases/postgresql90/Makefile.common" + +CONFIGURE_ARGS+= --with-ossp-uuid + +BUILD_DIRS+= contrib/citext +BUILD_DIRS+= contrib/hstore +BUILD_DIRS+= contrib/intarray +BUILD_DIRS+= contrib/isn +BUILD_DIRS+= contrib/ltree +BUILD_DIRS+= contrib/lo +BUILD_DIRS+= contrib/uuid-ossp +BUILD_DIRS+= contrib/unaccent + +USE_LIBTOOL= yes +PKG_LIBTOOL= ${PKG_SHLIBTOOL} + +REQD_DIRS+= ${PG_SUBPREFIX}lib/postgresql +REQD_DIRS+= ${PG_SUBPREFIX}share/postgresql/contrib + +.include "../../databases/postgresql90-client/buildlink3.mk" + +.include "../../devel/ossp-uuid/buildlink3.mk" +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql90-datatypes/PLIST b/databases/postgresql90-datatypes/PLIST new file mode 100644 index 00000000000..501a1714f7e --- /dev/null +++ b/databases/postgresql90-datatypes/PLIST @@ -0,0 +1,26 @@ +@comment $NetBSD: PLIST,v 1.1.1.1 2010/12/11 23:01:51 asau Exp $ +${PG_SUBPREFIX}lib/postgresql/_int.la +${PG_SUBPREFIX}lib/postgresql/citext.so +${PG_SUBPREFIX}lib/postgresql/hstore.la +${PG_SUBPREFIX}lib/postgresql/isn.so +${PG_SUBPREFIX}lib/postgresql/lo.so +${PG_SUBPREFIX}lib/postgresql/ltree.la +${PG_SUBPREFIX}lib/postgresql/unaccent.la +${PG_SUBPREFIX}lib/postgresql/uuid-ossp.la +${PG_SUBPREFIX}share/postgresql/contrib/_int.sql +${PG_SUBPREFIX}share/postgresql/contrib/citext.sql +${PG_SUBPREFIX}share/postgresql/contrib/hstore.sql +${PG_SUBPREFIX}share/postgresql/contrib/isn.sql +${PG_SUBPREFIX}share/postgresql/contrib/lo.sql +${PG_SUBPREFIX}share/postgresql/contrib/ltree.sql +${PG_SUBPREFIX}share/postgresql/contrib/unaccent.sql +${PG_SUBPREFIX}share/postgresql/contrib/uninstall__int.sql +${PG_SUBPREFIX}share/postgresql/contrib/uninstall_citext.sql +${PG_SUBPREFIX}share/postgresql/contrib/uninstall_hstore.sql +${PG_SUBPREFIX}share/postgresql/contrib/uninstall_isn.sql +${PG_SUBPREFIX}share/postgresql/contrib/uninstall_lo.sql +${PG_SUBPREFIX}share/postgresql/contrib/uninstall_ltree.sql +${PG_SUBPREFIX}share/postgresql/contrib/uninstall_unaccent.sql +${PG_SUBPREFIX}share/postgresql/contrib/uninstall_uuid-ossp.sql +${PG_SUBPREFIX}share/postgresql/contrib/uuid-ossp.sql +${PG_SUBPREFIX}share/postgresql/tsearch_data/unaccent.rules |