Copyright	2015 Dylan Simon
Safe Haskell	Safe-Inferred
Language	Haskell2010

Database.PostgreSQL.Typed.Array

Contents

Orphan instances

Description

Representaion of PostgreSQL's array type. Currently this only supports one-dimensional arrays. PostgreSQL arrays in theory can dynamically be any (rectangular) shape.

Synopsis

type PGArray a = [Maybe a]
class (PGType t, PGType (PGElemType t)) => PGArrayType t where
- type PGElemType t :: Symbol
- pgArrayElementType :: PGTypeID t -> PGTypeID (PGElemType t)
- pgArrayDelim :: PGTypeID t -> Char

Documentation

type PGArray a = [Maybe a] Source #

The cannonical representation of a PostgreSQL array of any type, which may always contain NULLs. Currenly only one-dimetional arrays are supported, although in PostgreSQL, any array may be of any dimentionality.

class (PGType t, PGType (PGElemType t)) => PGArrayType t where Source #

Class indicating that the first PostgreSQL type is an array of the second. This implies PGParameter and PGColumn instances that will work for any type using comma as a delimiter (i.e., anything but box). This will only work with 1-dimensional arrays.

Minimal complete definition

Nothing

Associated Types

type PGElemType t :: Symbol Source #

Methods

pgArrayElementType :: PGTypeID t -> PGTypeID (PGElemType t) Source #

pgArrayDelim :: PGTypeID t -> Char Source #

The character used as a delimeter. The default , is correct for all standard types (except box).

Instances

Instances details

PGType "\"char\"" => PGArrayType "\"char\"[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "\"char\"[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "\"char\"[]" -> PGTypeID (PGElemType "\"char\"[]") Source # pgArrayDelim :: PGTypeID "\"char\"[]" -> Char Source #
PGType "abstime" => PGArrayType "abstime[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "abstime[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "abstime[]" -> PGTypeID (PGElemType "abstime[]") Source # pgArrayDelim :: PGTypeID "abstime[]" -> Char Source #
PGType "aclitem" => PGArrayType "aclitem[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "aclitem[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "aclitem[]" -> PGTypeID (PGElemType "aclitem[]") Source # pgArrayDelim :: PGTypeID "aclitem[]" -> Char Source #
PGType "bigint" => PGArrayType "bigint[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "bigint[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "bigint[]" -> PGTypeID (PGElemType "bigint[]") Source # pgArrayDelim :: PGTypeID "bigint[]" -> Char Source #
PGType "bit" => PGArrayType "bit[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "bit[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "bit[]" -> PGTypeID (PGElemType "bit[]") Source # pgArrayDelim :: PGTypeID "bit[]" -> Char Source #
PGType "boolean" => PGArrayType "boolean[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "boolean[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "boolean[]" -> PGTypeID (PGElemType "boolean[]") Source # pgArrayDelim :: PGTypeID "boolean[]" -> Char Source #
PGType "box" => PGArrayType "box[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "box[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "box[]" -> PGTypeID (PGElemType "box[]") Source # pgArrayDelim :: PGTypeID "box[]" -> Char Source #
PGType "bpchar" => PGArrayType "bpchar[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "bpchar[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "bpchar[]" -> PGTypeID (PGElemType "bpchar[]") Source # pgArrayDelim :: PGTypeID "bpchar[]" -> Char Source #
PGType "bytea" => PGArrayType "bytea[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "bytea[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "bytea[]" -> PGTypeID (PGElemType "bytea[]") Source # pgArrayDelim :: PGTypeID "bytea[]" -> Char Source #
PGType "character varying" => PGArrayType "character varying[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "character varying[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "character varying[]" -> PGTypeID (PGElemType "character varying[]") Source # pgArrayDelim :: PGTypeID "character varying[]" -> Char Source #
PGType "cid" => PGArrayType "cid[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "cid[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "cid[]" -> PGTypeID (PGElemType "cid[]") Source # pgArrayDelim :: PGTypeID "cid[]" -> Char Source #
PGType "cidr" => PGArrayType "cidr[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "cidr[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "cidr[]" -> PGTypeID (PGElemType "cidr[]") Source # pgArrayDelim :: PGTypeID "cidr[]" -> Char Source #
PGType "circle" => PGArrayType "circle[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "circle[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "circle[]" -> PGTypeID (PGElemType "circle[]") Source # pgArrayDelim :: PGTypeID "circle[]" -> Char Source #
PGType "cstring" => PGArrayType "cstring[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "cstring[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "cstring[]" -> PGTypeID (PGElemType "cstring[]") Source # pgArrayDelim :: PGTypeID "cstring[]" -> Char Source #
PGType "date" => PGArrayType "date[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "date[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "date[]" -> PGTypeID (PGElemType "date[]") Source # pgArrayDelim :: PGTypeID "date[]" -> Char Source #
PGType "daterange" => PGArrayType "daterange[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "daterange[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "daterange[]" -> PGTypeID (PGElemType "daterange[]") Source # pgArrayDelim :: PGTypeID "daterange[]" -> Char Source #
PGType "double precision" => PGArrayType "double precision[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "double precision[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "double precision[]" -> PGTypeID (PGElemType "double precision[]") Source # pgArrayDelim :: PGTypeID "double precision[]" -> Char Source #
PGType "gtsvector" => PGArrayType "gtsvector[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "gtsvector[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "gtsvector[]" -> PGTypeID (PGElemType "gtsvector[]") Source # pgArrayDelim :: PGTypeID "gtsvector[]" -> Char Source #
PGType "inet" => PGArrayType "inet[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "inet[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "inet[]" -> PGTypeID (PGElemType "inet[]") Source # pgArrayDelim :: PGTypeID "inet[]" -> Char Source #
PGType "int2vector" => PGArrayType "int2vector[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "int2vector[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "int2vector[]" -> PGTypeID (PGElemType "int2vector[]") Source # pgArrayDelim :: PGTypeID "int2vector[]" -> Char Source #
PGType "int4range" => PGArrayType "int4range[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "int4range[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "int4range[]" -> PGTypeID (PGElemType "int4range[]") Source # pgArrayDelim :: PGTypeID "int4range[]" -> Char Source #
PGType "int8range" => PGArrayType "int8range[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "int8range[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "int8range[]" -> PGTypeID (PGElemType "int8range[]") Source # pgArrayDelim :: PGTypeID "int8range[]" -> Char Source #
PGType "integer" => PGArrayType "integer[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "integer[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "integer[]" -> PGTypeID (PGElemType "integer[]") Source # pgArrayDelim :: PGTypeID "integer[]" -> Char Source #
PGType "interval" => PGArrayType "interval[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "interval[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "interval[]" -> PGTypeID (PGElemType "interval[]") Source # pgArrayDelim :: PGTypeID "interval[]" -> Char Source #
PGType "json" => PGArrayType "json[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "json[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "json[]" -> PGTypeID (PGElemType "json[]") Source # pgArrayDelim :: PGTypeID "json[]" -> Char Source #
PGType "line" => PGArrayType "line[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "line[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "line[]" -> PGTypeID (PGElemType "line[]") Source # pgArrayDelim :: PGTypeID "line[]" -> Char Source #
PGType "lseg" => PGArrayType "lseg[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "lseg[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "lseg[]" -> PGTypeID (PGElemType "lseg[]") Source # pgArrayDelim :: PGTypeID "lseg[]" -> Char Source #
PGType "macaddr" => PGArrayType "macaddr[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "macaddr[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "macaddr[]" -> PGTypeID (PGElemType "macaddr[]") Source # pgArrayDelim :: PGTypeID "macaddr[]" -> Char Source #
PGType "money" => PGArrayType "money[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "money[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "money[]" -> PGTypeID (PGElemType "money[]") Source # pgArrayDelim :: PGTypeID "money[]" -> Char Source #
PGType "name" => PGArrayType "name[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "name[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "name[]" -> PGTypeID (PGElemType "name[]") Source # pgArrayDelim :: PGTypeID "name[]" -> Char Source #
PGType "numeric" => PGArrayType "numeric[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "numeric[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "numeric[]" -> PGTypeID (PGElemType "numeric[]") Source # pgArrayDelim :: PGTypeID "numeric[]" -> Char Source #
PGType "numrange" => PGArrayType "numrange[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "numrange[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "numrange[]" -> PGTypeID (PGElemType "numrange[]") Source # pgArrayDelim :: PGTypeID "numrange[]" -> Char Source #
PGType "oid" => PGArrayType "oid[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "oid[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "oid[]" -> PGTypeID (PGElemType "oid[]") Source # pgArrayDelim :: PGTypeID "oid[]" -> Char Source #
PGType "oidvector" => PGArrayType "oidvector[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "oidvector[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "oidvector[]" -> PGTypeID (PGElemType "oidvector[]") Source # pgArrayDelim :: PGTypeID "oidvector[]" -> Char Source #
PGType "path" => PGArrayType "path[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "path[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "path[]" -> PGTypeID (PGElemType "path[]") Source # pgArrayDelim :: PGTypeID "path[]" -> Char Source #
PGType "point" => PGArrayType "point[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "point[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "point[]" -> PGTypeID (PGElemType "point[]") Source # pgArrayDelim :: PGTypeID "point[]" -> Char Source #
PGType "polygon" => PGArrayType "polygon[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "polygon[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "polygon[]" -> PGTypeID (PGElemType "polygon[]") Source # pgArrayDelim :: PGTypeID "polygon[]" -> Char Source #
PGType "real" => PGArrayType "real[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "real[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "real[]" -> PGTypeID (PGElemType "real[]") Source # pgArrayDelim :: PGTypeID "real[]" -> Char Source #
PGType "record" => PGArrayType "record[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "record[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "record[]" -> PGTypeID (PGElemType "record[]") Source # pgArrayDelim :: PGTypeID "record[]" -> Char Source #
PGType "refcursor" => PGArrayType "refcursor[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "refcursor[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "refcursor[]" -> PGTypeID (PGElemType "refcursor[]") Source # pgArrayDelim :: PGTypeID "refcursor[]" -> Char Source #
PGType "regclass" => PGArrayType "regclass[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "regclass[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "regclass[]" -> PGTypeID (PGElemType "regclass[]") Source # pgArrayDelim :: PGTypeID "regclass[]" -> Char Source #
PGType "regconfig" => PGArrayType "regconfig[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "regconfig[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "regconfig[]" -> PGTypeID (PGElemType "regconfig[]") Source # pgArrayDelim :: PGTypeID "regconfig[]" -> Char Source #
PGType "regdictionary" => PGArrayType "regdictionary[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "regdictionary[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "regdictionary[]" -> PGTypeID (PGElemType "regdictionary[]") Source # pgArrayDelim :: PGTypeID "regdictionary[]" -> Char Source #
PGType "regoper" => PGArrayType "regoper[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "regoper[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "regoper[]" -> PGTypeID (PGElemType "regoper[]") Source # pgArrayDelim :: PGTypeID "regoper[]" -> Char Source #
PGType "regoperator" => PGArrayType "regoperator[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "regoperator[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "regoperator[]" -> PGTypeID (PGElemType "regoperator[]") Source # pgArrayDelim :: PGTypeID "regoperator[]" -> Char Source #
PGType "regproc" => PGArrayType "regproc[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "regproc[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "regproc[]" -> PGTypeID (PGElemType "regproc[]") Source # pgArrayDelim :: PGTypeID "regproc[]" -> Char Source #
PGType "regprocedure" => PGArrayType "regprocedure[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "regprocedure[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "regprocedure[]" -> PGTypeID (PGElemType "regprocedure[]") Source # pgArrayDelim :: PGTypeID "regprocedure[]" -> Char Source #
PGType "regtype" => PGArrayType "regtype[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "regtype[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "regtype[]" -> PGTypeID (PGElemType "regtype[]") Source # pgArrayDelim :: PGTypeID "regtype[]" -> Char Source #
PGType "reltime" => PGArrayType "reltime[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "reltime[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "reltime[]" -> PGTypeID (PGElemType "reltime[]") Source # pgArrayDelim :: PGTypeID "reltime[]" -> Char Source #
PGType "smallint" => PGArrayType "smallint[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "smallint[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "smallint[]" -> PGTypeID (PGElemType "smallint[]") Source # pgArrayDelim :: PGTypeID "smallint[]" -> Char Source #
PGType "text" => PGArrayType "text[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "text[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "text[]" -> PGTypeID (PGElemType "text[]") Source # pgArrayDelim :: PGTypeID "text[]" -> Char Source #
PGType "tid" => PGArrayType "tid[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "tid[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "tid[]" -> PGTypeID (PGElemType "tid[]") Source # pgArrayDelim :: PGTypeID "tid[]" -> Char Source #
PGType "time with time zone" => PGArrayType "time with time zone[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "time with time zone[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "time with time zone[]" -> PGTypeID (PGElemType "time with time zone[]") Source # pgArrayDelim :: PGTypeID "time with time zone[]" -> Char Source #
PGType "time without time zone" => PGArrayType "time without time zone[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "time without time zone[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "time without time zone[]" -> PGTypeID (PGElemType "time without time zone[]") Source # pgArrayDelim :: PGTypeID "time without time zone[]" -> Char Source #
PGType "timestamp with time zone" => PGArrayType "timestamp with time zone[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "timestamp with time zone[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "timestamp with time zone[]" -> PGTypeID (PGElemType "timestamp with time zone[]") Source # pgArrayDelim :: PGTypeID "timestamp with time zone[]" -> Char Source #
PGType "timestamp without time zone" => PGArrayType "timestamp without time zone[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "timestamp without time zone[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "timestamp without time zone[]" -> PGTypeID (PGElemType "timestamp without time zone[]") Source # pgArrayDelim :: PGTypeID "timestamp without time zone[]" -> Char Source #
PGType "tinterval" => PGArrayType "tinterval[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "tinterval[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "tinterval[]" -> PGTypeID (PGElemType "tinterval[]") Source # pgArrayDelim :: PGTypeID "tinterval[]" -> Char Source #
PGType "tsquery" => PGArrayType "tsquery[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "tsquery[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "tsquery[]" -> PGTypeID (PGElemType "tsquery[]") Source # pgArrayDelim :: PGTypeID "tsquery[]" -> Char Source #
PGType "tsrange" => PGArrayType "tsrange[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "tsrange[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "tsrange[]" -> PGTypeID (PGElemType "tsrange[]") Source # pgArrayDelim :: PGTypeID "tsrange[]" -> Char Source #
PGType "tstzrange" => PGArrayType "tstzrange[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "tstzrange[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "tstzrange[]" -> PGTypeID (PGElemType "tstzrange[]") Source # pgArrayDelim :: PGTypeID "tstzrange[]" -> Char Source #
PGType "tsvector" => PGArrayType "tsvector[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "tsvector[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "tsvector[]" -> PGTypeID (PGElemType "tsvector[]") Source # pgArrayDelim :: PGTypeID "tsvector[]" -> Char Source #
PGType "txid_snapshot" => PGArrayType "txid_snapshot[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "txid_snapshot[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "txid_snapshot[]" -> PGTypeID (PGElemType "txid_snapshot[]") Source # pgArrayDelim :: PGTypeID "txid_snapshot[]" -> Char Source #
PGType "uuid" => PGArrayType "uuid[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "uuid[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "uuid[]" -> PGTypeID (PGElemType "uuid[]") Source # pgArrayDelim :: PGTypeID "uuid[]" -> Char Source #
PGType "varbit" => PGArrayType "varbit[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "varbit[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "varbit[]" -> PGTypeID (PGElemType "varbit[]") Source # pgArrayDelim :: PGTypeID "varbit[]" -> Char Source #
PGType "xid" => PGArrayType "xid[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "xid[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "xid[]" -> PGTypeID (PGElemType "xid[]") Source # pgArrayDelim :: PGTypeID "xid[]" -> Char Source #
PGType "xml" => PGArrayType "xml[]" Source #
Instance details Defined in Database.PostgreSQL.Typed.Array Associated Types type PGElemType "xml[]" :: Symbol Source # Methods pgArrayElementType :: PGTypeID "xml[]" -> PGTypeID (PGElemType "xml[]") Source # pgArrayDelim :: PGTypeID "xml[]" -> Char Source #

Orphan instances

PGType "\"char\"" => PGType "\"char\"[]" Source #
Instance details Associated Types type PGVal "\"char\"[]" Source # Methods pgTypeName :: PGTypeID "\"char\"[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "\"char\"[]" -> Bool Source #
PGType "abstime" => PGType "abstime[]" Source #
Instance details Associated Types type PGVal "abstime[]" Source # Methods pgTypeName :: PGTypeID "abstime[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "abstime[]" -> Bool Source #
PGType "aclitem" => PGType "aclitem[]" Source #
Instance details Associated Types type PGVal "aclitem[]" Source # Methods pgTypeName :: PGTypeID "aclitem[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "aclitem[]" -> Bool Source #
PGType "bigint" => PGType "bigint[]" Source #
Instance details Associated Types type PGVal "bigint[]" Source # Methods pgTypeName :: PGTypeID "bigint[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "bigint[]" -> Bool Source #
PGType "bit" => PGType "bit[]" Source #
Instance details Associated Types type PGVal "bit[]" Source # Methods pgTypeName :: PGTypeID "bit[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "bit[]" -> Bool Source #
PGType "boolean" => PGType "boolean[]" Source #
Instance details Associated Types type PGVal "boolean[]" Source # Methods pgTypeName :: PGTypeID "boolean[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "boolean[]" -> Bool Source #
PGType "box" => PGType "box[]" Source #
Instance details Associated Types type PGVal "box[]" Source # Methods pgTypeName :: PGTypeID "box[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "box[]" -> Bool Source #
PGType "bpchar" => PGType "bpchar[]" Source #
Instance details Associated Types type PGVal "bpchar[]" Source # Methods pgTypeName :: PGTypeID "bpchar[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "bpchar[]" -> Bool Source #
PGType "bytea" => PGType "bytea[]" Source #
Instance details Associated Types type PGVal "bytea[]" Source # Methods pgTypeName :: PGTypeID "bytea[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "bytea[]" -> Bool Source #
PGType "character varying" => PGType "character varying[]" Source #
Instance details Associated Types type PGVal "character varying[]" Source # Methods pgTypeName :: PGTypeID "character varying[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "character varying[]" -> Bool Source #
PGType "cid" => PGType "cid[]" Source #
Instance details Associated Types type PGVal "cid[]" Source # Methods pgTypeName :: PGTypeID "cid[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "cid[]" -> Bool Source #
PGType "cidr" => PGType "cidr[]" Source #
Instance details Associated Types type PGVal "cidr[]" Source # Methods pgTypeName :: PGTypeID "cidr[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "cidr[]" -> Bool Source #
PGType "circle" => PGType "circle[]" Source #
Instance details Associated Types type PGVal "circle[]" Source # Methods pgTypeName :: PGTypeID "circle[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "circle[]" -> Bool Source #
PGType "cstring" => PGType "cstring[]" Source #
Instance details Associated Types type PGVal "cstring[]" Source # Methods pgTypeName :: PGTypeID "cstring[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "cstring[]" -> Bool Source #
PGType "date" => PGType "date[]" Source #
Instance details Associated Types type PGVal "date[]" Source # Methods pgTypeName :: PGTypeID "date[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "date[]" -> Bool Source #
PGType "daterange" => PGType "daterange[]" Source #
Instance details Associated Types type PGVal "daterange[]" Source # Methods pgTypeName :: PGTypeID "daterange[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "daterange[]" -> Bool Source #
PGType "double precision" => PGType "double precision[]" Source #
Instance details Associated Types type PGVal "double precision[]" Source # Methods pgTypeName :: PGTypeID "double precision[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "double precision[]" -> Bool Source #
PGType "gtsvector" => PGType "gtsvector[]" Source #
Instance details Associated Types type PGVal "gtsvector[]" Source # Methods pgTypeName :: PGTypeID "gtsvector[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "gtsvector[]" -> Bool Source #
PGType "inet" => PGType "inet[]" Source #
Instance details Associated Types type PGVal "inet[]" Source # Methods pgTypeName :: PGTypeID "inet[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "inet[]" -> Bool Source #
PGType "int2vector" => PGType "int2vector[]" Source #
Instance details Associated Types type PGVal "int2vector[]" Source # Methods pgTypeName :: PGTypeID "int2vector[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "int2vector[]" -> Bool Source #
PGType "int4range" => PGType "int4range[]" Source #
Instance details Associated Types type PGVal "int4range[]" Source # Methods pgTypeName :: PGTypeID "int4range[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "int4range[]" -> Bool Source #
PGType "int8range" => PGType "int8range[]" Source #
Instance details Associated Types type PGVal "int8range[]" Source # Methods pgTypeName :: PGTypeID "int8range[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "int8range[]" -> Bool Source #
PGType "integer" => PGType "integer[]" Source #
Instance details Associated Types type PGVal "integer[]" Source # Methods pgTypeName :: PGTypeID "integer[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "integer[]" -> Bool Source #
PGType "interval" => PGType "interval[]" Source #
Instance details Associated Types type PGVal "interval[]" Source # Methods pgTypeName :: PGTypeID "interval[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "interval[]" -> Bool Source #
PGType "json" => PGType "json[]" Source #
Instance details Associated Types type PGVal "json[]" Source # Methods pgTypeName :: PGTypeID "json[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "json[]" -> Bool Source #
PGType "line" => PGType "line[]" Source #
Instance details Associated Types type PGVal "line[]" Source # Methods pgTypeName :: PGTypeID "line[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "line[]" -> Bool Source #
PGType "lseg" => PGType "lseg[]" Source #
Instance details Associated Types type PGVal "lseg[]" Source # Methods pgTypeName :: PGTypeID "lseg[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "lseg[]" -> Bool Source #
PGType "macaddr" => PGType "macaddr[]" Source #
Instance details Associated Types type PGVal "macaddr[]" Source # Methods pgTypeName :: PGTypeID "macaddr[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "macaddr[]" -> Bool Source #
PGType "money" => PGType "money[]" Source #
Instance details Associated Types type PGVal "money[]" Source # Methods pgTypeName :: PGTypeID "money[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "money[]" -> Bool Source #
PGType "name" => PGType "name[]" Source #
Instance details Associated Types type PGVal "name[]" Source # Methods pgTypeName :: PGTypeID "name[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "name[]" -> Bool Source #
PGType "numeric" => PGType "numeric[]" Source #
Instance details Associated Types type PGVal "numeric[]" Source # Methods pgTypeName :: PGTypeID "numeric[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "numeric[]" -> Bool Source #
PGType "numrange" => PGType "numrange[]" Source #
Instance details Associated Types type PGVal "numrange[]" Source # Methods pgTypeName :: PGTypeID "numrange[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "numrange[]" -> Bool Source #
PGType "oid" => PGType "oid[]" Source #
Instance details Associated Types type PGVal "oid[]" Source # Methods pgTypeName :: PGTypeID "oid[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "oid[]" -> Bool Source #
PGType "oidvector" => PGType "oidvector[]" Source #
Instance details Associated Types type PGVal "oidvector[]" Source # Methods pgTypeName :: PGTypeID "oidvector[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "oidvector[]" -> Bool Source #
PGType "path" => PGType "path[]" Source #
Instance details Associated Types type PGVal "path[]" Source # Methods pgTypeName :: PGTypeID "path[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "path[]" -> Bool Source #
PGType "point" => PGType "point[]" Source #
Instance details Associated Types type PGVal "point[]" Source # Methods pgTypeName :: PGTypeID "point[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "point[]" -> Bool Source #
PGType "polygon" => PGType "polygon[]" Source #
Instance details Associated Types type PGVal "polygon[]" Source # Methods pgTypeName :: PGTypeID "polygon[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "polygon[]" -> Bool Source #
PGType "real" => PGType "real[]" Source #
Instance details Associated Types type PGVal "real[]" Source # Methods pgTypeName :: PGTypeID "real[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "real[]" -> Bool Source #
PGType "record" => PGType "record[]" Source #
Instance details Associated Types type PGVal "record[]" Source # Methods pgTypeName :: PGTypeID "record[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "record[]" -> Bool Source #
PGType "refcursor" => PGType "refcursor[]" Source #
Instance details Associated Types type PGVal "refcursor[]" Source # Methods pgTypeName :: PGTypeID "refcursor[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "refcursor[]" -> Bool Source #
PGType "regclass" => PGType "regclass[]" Source #
Instance details Associated Types type PGVal "regclass[]" Source # Methods pgTypeName :: PGTypeID "regclass[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "regclass[]" -> Bool Source #
PGType "regconfig" => PGType "regconfig[]" Source #
Instance details Associated Types type PGVal "regconfig[]" Source # Methods pgTypeName :: PGTypeID "regconfig[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "regconfig[]" -> Bool Source #
PGType "regdictionary" => PGType "regdictionary[]" Source #
Instance details Associated Types type PGVal "regdictionary[]" Source # Methods pgTypeName :: PGTypeID "regdictionary[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "regdictionary[]" -> Bool Source #
PGType "regoper" => PGType "regoper[]" Source #
Instance details Associated Types type PGVal "regoper[]" Source # Methods pgTypeName :: PGTypeID "regoper[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "regoper[]" -> Bool Source #
PGType "regoperator" => PGType "regoperator[]" Source #
Instance details Associated Types type PGVal "regoperator[]" Source # Methods pgTypeName :: PGTypeID "regoperator[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "regoperator[]" -> Bool Source #
PGType "regproc" => PGType "regproc[]" Source #
Instance details Associated Types type PGVal "regproc[]" Source # Methods pgTypeName :: PGTypeID "regproc[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "regproc[]" -> Bool Source #
PGType "regprocedure" => PGType "regprocedure[]" Source #
Instance details Associated Types type PGVal "regprocedure[]" Source # Methods pgTypeName :: PGTypeID "regprocedure[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "regprocedure[]" -> Bool Source #
PGType "regtype" => PGType "regtype[]" Source #
Instance details Associated Types type PGVal "regtype[]" Source # Methods pgTypeName :: PGTypeID "regtype[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "regtype[]" -> Bool Source #
PGType "reltime" => PGType "reltime[]" Source #
Instance details Associated Types type PGVal "reltime[]" Source # Methods pgTypeName :: PGTypeID "reltime[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "reltime[]" -> Bool Source #
PGType "smallint" => PGType "smallint[]" Source #
Instance details Associated Types type PGVal "smallint[]" Source # Methods pgTypeName :: PGTypeID "smallint[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "smallint[]" -> Bool Source #
PGType "text" => PGType "text[]" Source #
Instance details Associated Types type PGVal "text[]" Source # Methods pgTypeName :: PGTypeID "text[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "text[]" -> Bool Source #
PGType "tid" => PGType "tid[]" Source #
Instance details Associated Types type PGVal "tid[]" Source # Methods pgTypeName :: PGTypeID "tid[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "tid[]" -> Bool Source #
PGType "time with time zone" => PGType "time with time zone[]" Source #
Instance details Associated Types type PGVal "time with time zone[]" Source # Methods pgTypeName :: PGTypeID "time with time zone[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "time with time zone[]" -> Bool Source #
PGType "time without time zone" => PGType "time without time zone[]" Source #
Instance details Associated Types type PGVal "time without time zone[]" Source # Methods pgTypeName :: PGTypeID "time without time zone[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "time without time zone[]" -> Bool Source #
PGType "timestamp with time zone" => PGType "timestamp with time zone[]" Source #
Instance details Associated Types type PGVal "timestamp with time zone[]" Source # Methods pgTypeName :: PGTypeID "timestamp with time zone[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "timestamp with time zone[]" -> Bool Source #
PGType "timestamp without time zone" => PGType "timestamp without time zone[]" Source #
Instance details Associated Types type PGVal "timestamp without time zone[]" Source # Methods pgTypeName :: PGTypeID "timestamp without time zone[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "timestamp without time zone[]" -> Bool Source #
PGType "tinterval" => PGType "tinterval[]" Source #
Instance details Associated Types type PGVal "tinterval[]" Source # Methods pgTypeName :: PGTypeID "tinterval[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "tinterval[]" -> Bool Source #
PGType "tsquery" => PGType "tsquery[]" Source #
Instance details Associated Types type PGVal "tsquery[]" Source # Methods pgTypeName :: PGTypeID "tsquery[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "tsquery[]" -> Bool Source #
PGType "tsrange" => PGType "tsrange[]" Source #
Instance details Associated Types type PGVal "tsrange[]" Source # Methods pgTypeName :: PGTypeID "tsrange[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "tsrange[]" -> Bool Source #
PGType "tstzrange" => PGType "tstzrange[]" Source #
Instance details Associated Types type PGVal "tstzrange[]" Source # Methods pgTypeName :: PGTypeID "tstzrange[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "tstzrange[]" -> Bool Source #
PGType "tsvector" => PGType "tsvector[]" Source #
Instance details Associated Types type PGVal "tsvector[]" Source # Methods pgTypeName :: PGTypeID "tsvector[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "tsvector[]" -> Bool Source #
PGType "txid_snapshot" => PGType "txid_snapshot[]" Source #
Instance details Associated Types type PGVal "txid_snapshot[]" Source # Methods pgTypeName :: PGTypeID "txid_snapshot[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "txid_snapshot[]" -> Bool Source #
PGType "uuid" => PGType "uuid[]" Source #
Instance details Associated Types type PGVal "uuid[]" Source # Methods pgTypeName :: PGTypeID "uuid[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "uuid[]" -> Bool Source #
PGType "varbit" => PGType "varbit[]" Source #
Instance details Associated Types type PGVal "varbit[]" Source # Methods pgTypeName :: PGTypeID "varbit[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "varbit[]" -> Bool Source #
PGType "xid" => PGType "xid[]" Source #
Instance details Associated Types type PGVal "xid[]" Source # Methods pgTypeName :: PGTypeID "xid[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "xid[]" -> Bool Source #
PGType "xml" => PGType "xml[]" Source #
Instance details Associated Types type PGVal "xml[]" Source # Methods pgTypeName :: PGTypeID "xml[]" -> PGName Source # pgBinaryColumn :: PGTypeEnv -> PGTypeID "xml[]" -> Bool Source #
(PGArrayType t, PGColumn (PGElemType t) a) => PGColumn t (PGArray a) Source #
Instance details Methods pgDecode :: PGTypeID t -> PGTextValue -> PGArray a Source # pgDecodeBinary :: PGTypeEnv -> PGTypeID t -> PGBinaryValue -> PGArray a Source # pgDecodeValue :: PGTypeEnv -> PGTypeID t -> PGValue -> PGArray a Source #
(PGArrayType t, PGParameter (PGElemType t) a) => PGParameter t (PGArray a) Source #
Instance details Methods pgEncode :: PGTypeID t -> PGArray a -> PGTextValue Source # pgLiteral :: PGTypeID t -> PGArray a -> ByteString Source # pgEncodeValue :: PGTypeEnv -> PGTypeID t -> PGArray a -> PGValue Source #
(PGArrayType t, PGParameter (PGElemType t) a) => PGParameter t [a] Source #	Allow entirely non-null arrays as parameter inputs only. (Only supported on ghc >= 7.10 due to instance overlap.)
Instance details Methods pgEncode :: PGTypeID t -> [a] -> PGTextValue Source # pgLiteral :: PGTypeID t -> [a] -> ByteString Source # pgEncodeValue :: PGTypeEnv -> PGTypeID t -> [a] -> PGValue Source #