Database.PostgreSQL.Typed.Array

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

Documentation

type PGArray a = [Maybe a]

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 ta, PGType t) => PGArrayType ta t | ta -> t, t -> ta where

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.

Methods

pgArrayElementType :: PGTypeName ta -> PGTypeName t

pgArrayDelim :: PGTypeName ta -> Char

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

Instances

PGType "\"char\"" => PGArrayType "\"char\"[]" "\"char\""

Methods

pgArrayElementType :: PGTypeName "\"char\"[]" -> PGTypeName "\"char\""

pgArrayDelim :: PGTypeName "\"char\"[]" -> Char

PGType "abstime" => PGArrayType "abstime[]" "abstime"

Methods

pgArrayElementType :: PGTypeName "abstime[]" -> PGTypeName "abstime"

pgArrayDelim :: PGTypeName "abstime[]" -> Char

PGType "aclitem" => PGArrayType "aclitem[]" "aclitem"

Methods

pgArrayElementType :: PGTypeName "aclitem[]" -> PGTypeName "aclitem"

pgArrayDelim :: PGTypeName "aclitem[]" -> Char

PGType "bigint" => PGArrayType "bigint[]" "bigint"

Methods

pgArrayElementType :: PGTypeName "bigint[]" -> PGTypeName "bigint"

pgArrayDelim :: PGTypeName "bigint[]" -> Char

PGType "bit" => PGArrayType "bit[]" "bit"

Methods

pgArrayElementType :: PGTypeName "bit[]" -> PGTypeName "bit"

pgArrayDelim :: PGTypeName "bit[]" -> Char

PGType "boolean" => PGArrayType "boolean[]" "boolean"

Methods

pgArrayElementType :: PGTypeName "boolean[]" -> PGTypeName "boolean"

pgArrayDelim :: PGTypeName "boolean[]" -> Char

PGType "box" => PGArrayType "box[]" "box"

Methods

pgArrayElementType :: PGTypeName "box[]" -> PGTypeName "box"

pgArrayDelim :: PGTypeName "box[]" -> Char

PGType "bpchar" => PGArrayType "bpchar[]" "bpchar"

Methods

pgArrayElementType :: PGTypeName "bpchar[]" -> PGTypeName "bpchar"

pgArrayDelim :: PGTypeName "bpchar[]" -> Char

PGType "bytea" => PGArrayType "bytea[]" "bytea"

Methods

pgArrayElementType :: PGTypeName "bytea[]" -> PGTypeName "bytea"

pgArrayDelim :: PGTypeName "bytea[]" -> Char

PGType "character varying" => PGArrayType "character varying[]" "character varying"

Methods

pgArrayElementType :: PGTypeName "character varying[]" -> PGTypeName "character varying"

pgArrayDelim :: PGTypeName "character varying[]" -> Char

PGType "cid" => PGArrayType "cid[]" "cid"

Methods

pgArrayElementType :: PGTypeName "cid[]" -> PGTypeName "cid"

pgArrayDelim :: PGTypeName "cid[]" -> Char

PGType "cidr" => PGArrayType "cidr[]" "cidr"

Methods

pgArrayElementType :: PGTypeName "cidr[]" -> PGTypeName "cidr"

pgArrayDelim :: PGTypeName "cidr[]" -> Char

PGType "circle" => PGArrayType "circle[]" "circle"

Methods

pgArrayElementType :: PGTypeName "circle[]" -> PGTypeName "circle"

pgArrayDelim :: PGTypeName "circle[]" -> Char

PGType "cstring" => PGArrayType "cstring[]" "cstring"

Methods

pgArrayElementType :: PGTypeName "cstring[]" -> PGTypeName "cstring"

pgArrayDelim :: PGTypeName "cstring[]" -> Char

PGType "date" => PGArrayType "date[]" "date"

Methods

pgArrayElementType :: PGTypeName "date[]" -> PGTypeName "date"

pgArrayDelim :: PGTypeName "date[]" -> Char

PGType "daterange" => PGArrayType "daterange[]" "daterange"

Methods

pgArrayElementType :: PGTypeName "daterange[]" -> PGTypeName "daterange"

pgArrayDelim :: PGTypeName "daterange[]" -> Char

PGType "double precision" => PGArrayType "double precision[]" "double precision"

Methods

pgArrayElementType :: PGTypeName "double precision[]" -> PGTypeName "double precision"

pgArrayDelim :: PGTypeName "double precision[]" -> Char

PGType "gtsvector" => PGArrayType "gtsvector[]" "gtsvector"

Methods

pgArrayElementType :: PGTypeName "gtsvector[]" -> PGTypeName "gtsvector"

pgArrayDelim :: PGTypeName "gtsvector[]" -> Char

PGType "inet" => PGArrayType "inet[]" "inet"

Methods

pgArrayElementType :: PGTypeName "inet[]" -> PGTypeName "inet"

pgArrayDelim :: PGTypeName "inet[]" -> Char

PGType "int2vector" => PGArrayType "int2vector[]" "int2vector"

Methods

pgArrayElementType :: PGTypeName "int2vector[]" -> PGTypeName "int2vector"

pgArrayDelim :: PGTypeName "int2vector[]" -> Char

PGType "int4range" => PGArrayType "int4range[]" "int4range"

Methods

pgArrayElementType :: PGTypeName "int4range[]" -> PGTypeName "int4range"

pgArrayDelim :: PGTypeName "int4range[]" -> Char

PGType "int8range" => PGArrayType "int8range[]" "int8range"

Methods

pgArrayElementType :: PGTypeName "int8range[]" -> PGTypeName "int8range"

pgArrayDelim :: PGTypeName "int8range[]" -> Char

PGType "integer" => PGArrayType "integer[]" "integer"

Methods

pgArrayElementType :: PGTypeName "integer[]" -> PGTypeName "integer"

pgArrayDelim :: PGTypeName "integer[]" -> Char

PGType "interval" => PGArrayType "interval[]" "interval"

Methods

pgArrayElementType :: PGTypeName "interval[]" -> PGTypeName "interval"

pgArrayDelim :: PGTypeName "interval[]" -> Char

PGType "json" => PGArrayType "json[]" "json"

Methods

pgArrayElementType :: PGTypeName "json[]" -> PGTypeName "json"

pgArrayDelim :: PGTypeName "json[]" -> Char

PGType "line" => PGArrayType "line[]" "line"

Methods

pgArrayElementType :: PGTypeName "line[]" -> PGTypeName "line"

pgArrayDelim :: PGTypeName "line[]" -> Char

PGType "lseg" => PGArrayType "lseg[]" "lseg"

Methods

pgArrayElementType :: PGTypeName "lseg[]" -> PGTypeName "lseg"

pgArrayDelim :: PGTypeName "lseg[]" -> Char

PGType "macaddr" => PGArrayType "macaddr[]" "macaddr"

Methods

pgArrayElementType :: PGTypeName "macaddr[]" -> PGTypeName "macaddr"

pgArrayDelim :: PGTypeName "macaddr[]" -> Char

PGType "money" => PGArrayType "money[]" "money"

Methods

pgArrayElementType :: PGTypeName "money[]" -> PGTypeName "money"

pgArrayDelim :: PGTypeName "money[]" -> Char

PGType "name" => PGArrayType "name[]" "name"

Methods

pgArrayElementType :: PGTypeName "name[]" -> PGTypeName "name"

pgArrayDelim :: PGTypeName "name[]" -> Char

PGType "numeric" => PGArrayType "numeric[]" "numeric"

Methods

pgArrayElementType :: PGTypeName "numeric[]" -> PGTypeName "numeric"

pgArrayDelim :: PGTypeName "numeric[]" -> Char

PGType "numrange" => PGArrayType "numrange[]" "numrange"

Methods

pgArrayElementType :: PGTypeName "numrange[]" -> PGTypeName "numrange"

pgArrayDelim :: PGTypeName "numrange[]" -> Char

PGType "oid" => PGArrayType "oid[]" "oid"

Methods

pgArrayElementType :: PGTypeName "oid[]" -> PGTypeName "oid"

pgArrayDelim :: PGTypeName "oid[]" -> Char

PGType "oidvector" => PGArrayType "oidvector[]" "oidvector"

Methods

pgArrayElementType :: PGTypeName "oidvector[]" -> PGTypeName "oidvector"

pgArrayDelim :: PGTypeName "oidvector[]" -> Char

PGType "path" => PGArrayType "path[]" "path"

Methods

pgArrayElementType :: PGTypeName "path[]" -> PGTypeName "path"

pgArrayDelim :: PGTypeName "path[]" -> Char

PGType "point" => PGArrayType "point[]" "point"

Methods

pgArrayElementType :: PGTypeName "point[]" -> PGTypeName "point"

pgArrayDelim :: PGTypeName "point[]" -> Char

PGType "polygon" => PGArrayType "polygon[]" "polygon"

Methods

pgArrayElementType :: PGTypeName "polygon[]" -> PGTypeName "polygon"

pgArrayDelim :: PGTypeName "polygon[]" -> Char

PGType "real" => PGArrayType "real[]" "real"

Methods

pgArrayElementType :: PGTypeName "real[]" -> PGTypeName "real"

pgArrayDelim :: PGTypeName "real[]" -> Char

PGType "record" => PGArrayType "record[]" "record"

Methods

pgArrayElementType :: PGTypeName "record[]" -> PGTypeName "record"

pgArrayDelim :: PGTypeName "record[]" -> Char

PGType "refcursor" => PGArrayType "refcursor[]" "refcursor"

Methods

pgArrayElementType :: PGTypeName "refcursor[]" -> PGTypeName "refcursor"

pgArrayDelim :: PGTypeName "refcursor[]" -> Char

PGType "regclass" => PGArrayType "regclass[]" "regclass"

Methods

pgArrayElementType :: PGTypeName "regclass[]" -> PGTypeName "regclass"

pgArrayDelim :: PGTypeName "regclass[]" -> Char

PGType "regconfig" => PGArrayType "regconfig[]" "regconfig"

Methods

pgArrayElementType :: PGTypeName "regconfig[]" -> PGTypeName "regconfig"

pgArrayDelim :: PGTypeName "regconfig[]" -> Char

PGType "regdictionary" => PGArrayType "regdictionary[]" "regdictionary"

Methods

pgArrayElementType :: PGTypeName "regdictionary[]" -> PGTypeName "regdictionary"

pgArrayDelim :: PGTypeName "regdictionary[]" -> Char

PGType "regoper" => PGArrayType "regoper[]" "regoper"

Methods

pgArrayElementType :: PGTypeName "regoper[]" -> PGTypeName "regoper"

pgArrayDelim :: PGTypeName "regoper[]" -> Char

PGType "regoperator" => PGArrayType "regoperator[]" "regoperator"

Methods

pgArrayElementType :: PGTypeName "regoperator[]" -> PGTypeName "regoperator"

pgArrayDelim :: PGTypeName "regoperator[]" -> Char

PGType "regproc" => PGArrayType "regproc[]" "regproc"

Methods

pgArrayElementType :: PGTypeName "regproc[]" -> PGTypeName "regproc"

pgArrayDelim :: PGTypeName "regproc[]" -> Char

PGType "regprocedure" => PGArrayType "regprocedure[]" "regprocedure"

Methods

pgArrayElementType :: PGTypeName "regprocedure[]" -> PGTypeName "regprocedure"

pgArrayDelim :: PGTypeName "regprocedure[]" -> Char

PGType "regtype" => PGArrayType "regtype[]" "regtype"

Methods

pgArrayElementType :: PGTypeName "regtype[]" -> PGTypeName "regtype"

pgArrayDelim :: PGTypeName "regtype[]" -> Char

PGType "reltime" => PGArrayType "reltime[]" "reltime"

Methods

pgArrayElementType :: PGTypeName "reltime[]" -> PGTypeName "reltime"

pgArrayDelim :: PGTypeName "reltime[]" -> Char

PGType "smallint" => PGArrayType "smallint[]" "smallint"

Methods

pgArrayElementType :: PGTypeName "smallint[]" -> PGTypeName "smallint"

pgArrayDelim :: PGTypeName "smallint[]" -> Char

PGType "text" => PGArrayType "text[]" "text"

Methods

pgArrayElementType :: PGTypeName "text[]" -> PGTypeName "text"

pgArrayDelim :: PGTypeName "text[]" -> Char

PGType "tid" => PGArrayType "tid[]" "tid"

Methods

pgArrayElementType :: PGTypeName "tid[]" -> PGTypeName "tid"

pgArrayDelim :: PGTypeName "tid[]" -> Char

PGType "time with time zone" => PGArrayType "time with time zone[]" "time with time zone"

Methods

pgArrayElementType :: PGTypeName "time with time zone[]" -> PGTypeName "time with time zone"

pgArrayDelim :: PGTypeName "time with time zone[]" -> Char

PGType "time without time zone" => PGArrayType "time without time zone[]" "time without time zone"

Methods

pgArrayElementType :: PGTypeName "time without time zone[]" -> PGTypeName "time without time zone"

pgArrayDelim :: PGTypeName "time without time zone[]" -> Char

PGType "timestamp with time zone" => PGArrayType "timestamp with time zone[]" "timestamp with time zone"

Methods

pgArrayElementType :: PGTypeName "timestamp with time zone[]" -> PGTypeName "timestamp with time zone"

pgArrayDelim :: PGTypeName "timestamp with time zone[]" -> Char

PGType "timestamp without time zone" => PGArrayType "timestamp without time zone[]" "timestamp without time zone"

Methods

pgArrayElementType :: PGTypeName "timestamp without time zone[]" -> PGTypeName "timestamp without time zone"

pgArrayDelim :: PGTypeName "timestamp without time zone[]" -> Char

PGType "tinterval" => PGArrayType "tinterval[]" "tinterval"

Methods

pgArrayElementType :: PGTypeName "tinterval[]" -> PGTypeName "tinterval"

pgArrayDelim :: PGTypeName "tinterval[]" -> Char

PGType "tsquery" => PGArrayType "tsquery[]" "tsquery"

Methods

pgArrayElementType :: PGTypeName "tsquery[]" -> PGTypeName "tsquery"

pgArrayDelim :: PGTypeName "tsquery[]" -> Char

PGType "tsrange" => PGArrayType "tsrange[]" "tsrange"

Methods

pgArrayElementType :: PGTypeName "tsrange[]" -> PGTypeName "tsrange"

pgArrayDelim :: PGTypeName "tsrange[]" -> Char

PGType "tstzrange" => PGArrayType "tstzrange[]" "tstzrange"

Methods

pgArrayElementType :: PGTypeName "tstzrange[]" -> PGTypeName "tstzrange"

pgArrayDelim :: PGTypeName "tstzrange[]" -> Char

PGType "tsvector" => PGArrayType "tsvector[]" "tsvector"

Methods

pgArrayElementType :: PGTypeName "tsvector[]" -> PGTypeName "tsvector"

pgArrayDelim :: PGTypeName "tsvector[]" -> Char

PGType "txid_snapshot" => PGArrayType "txid_snapshot[]" "txid_snapshot"

Methods

pgArrayElementType :: PGTypeName "txid_snapshot[]" -> PGTypeName "txid_snapshot"

pgArrayDelim :: PGTypeName "txid_snapshot[]" -> Char

PGType "uuid" => PGArrayType "uuid[]" "uuid"

Methods

pgArrayElementType :: PGTypeName "uuid[]" -> PGTypeName "uuid"

pgArrayDelim :: PGTypeName "uuid[]" -> Char

PGType "varbit" => PGArrayType "varbit[]" "varbit"

Methods

pgArrayElementType :: PGTypeName "varbit[]" -> PGTypeName "varbit"

pgArrayDelim :: PGTypeName "varbit[]" -> Char

PGType "xid" => PGArrayType "xid[]" "xid"

Methods

pgArrayElementType :: PGTypeName "xid[]" -> PGTypeName "xid"

pgArrayDelim :: PGTypeName "xid[]" -> Char

PGType "xml" => PGArrayType "xml[]" "xml"

Methods

pgArrayElementType :: PGTypeName "xml[]" -> PGTypeName "xml"

pgArrayDelim :: PGTypeName "xml[]" -> Char

Orphan instances

PGType "\"char\"" => PGType "\"char\"[]"

Methods

pgTypeName :: PGTypeName "\"char\"[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "\"char\"[]" -> Bool

PGType "abstime" => PGType "abstime[]"

Methods

pgTypeName :: PGTypeName "abstime[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "abstime[]" -> Bool

PGType "aclitem" => PGType "aclitem[]"

Methods

pgTypeName :: PGTypeName "aclitem[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "aclitem[]" -> Bool

PGType "bigint" => PGType "bigint[]"

Methods

pgTypeName :: PGTypeName "bigint[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "bigint[]" -> Bool

PGType "bit" => PGType "bit[]"

Methods

pgTypeName :: PGTypeName "bit[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "bit[]" -> Bool

PGType "boolean" => PGType "boolean[]"

Methods

pgTypeName :: PGTypeName "boolean[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "boolean[]" -> Bool

PGType "box" => PGType "box[]"

Methods

pgTypeName :: PGTypeName "box[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "box[]" -> Bool

PGType "bpchar" => PGType "bpchar[]"

Methods

pgTypeName :: PGTypeName "bpchar[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "bpchar[]" -> Bool

PGType "bytea" => PGType "bytea[]"

Methods

pgTypeName :: PGTypeName "bytea[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "bytea[]" -> Bool

PGType "character varying" => PGType "character varying[]"

Methods

pgTypeName :: PGTypeName "character varying[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "character varying[]" -> Bool

PGType "cid" => PGType "cid[]"

Methods

pgTypeName :: PGTypeName "cid[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "cid[]" -> Bool

PGType "cidr" => PGType "cidr[]"

Methods

pgTypeName :: PGTypeName "cidr[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "cidr[]" -> Bool

PGType "circle" => PGType "circle[]"

Methods

pgTypeName :: PGTypeName "circle[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "circle[]" -> Bool

PGType "cstring" => PGType "cstring[]"

Methods

pgTypeName :: PGTypeName "cstring[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "cstring[]" -> Bool

PGType "date" => PGType "date[]"

Methods

pgTypeName :: PGTypeName "date[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "date[]" -> Bool

PGType "daterange" => PGType "daterange[]"

Methods

pgTypeName :: PGTypeName "daterange[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "daterange[]" -> Bool

PGType "double precision" => PGType "double precision[]"

Methods

pgTypeName :: PGTypeName "double precision[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "double precision[]" -> Bool

PGType "gtsvector" => PGType "gtsvector[]"

Methods

pgTypeName :: PGTypeName "gtsvector[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "gtsvector[]" -> Bool

PGType "inet" => PGType "inet[]"

Methods

pgTypeName :: PGTypeName "inet[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "inet[]" -> Bool

PGType "int2vector" => PGType "int2vector[]"

Methods

pgTypeName :: PGTypeName "int2vector[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "int2vector[]" -> Bool

PGType "int4range" => PGType "int4range[]"

Methods

pgTypeName :: PGTypeName "int4range[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "int4range[]" -> Bool

PGType "int8range" => PGType "int8range[]"

Methods

pgTypeName :: PGTypeName "int8range[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "int8range[]" -> Bool

PGType "integer" => PGType "integer[]"

Methods

pgTypeName :: PGTypeName "integer[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "integer[]" -> Bool

PGType "interval" => PGType "interval[]"

Methods

pgTypeName :: PGTypeName "interval[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "interval[]" -> Bool

PGType "json" => PGType "json[]"

Methods

pgTypeName :: PGTypeName "json[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "json[]" -> Bool

PGType "line" => PGType "line[]"

Methods

pgTypeName :: PGTypeName "line[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "line[]" -> Bool

PGType "lseg" => PGType "lseg[]"

Methods

pgTypeName :: PGTypeName "lseg[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "lseg[]" -> Bool

PGType "macaddr" => PGType "macaddr[]"

Methods

pgTypeName :: PGTypeName "macaddr[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "macaddr[]" -> Bool

PGType "money" => PGType "money[]"

Methods

pgTypeName :: PGTypeName "money[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "money[]" -> Bool

PGType "name" => PGType "name[]"

Methods

pgTypeName :: PGTypeName "name[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "name[]" -> Bool

PGType "numeric" => PGType "numeric[]"

Methods

pgTypeName :: PGTypeName "numeric[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "numeric[]" -> Bool

PGType "numrange" => PGType "numrange[]"

Methods

pgTypeName :: PGTypeName "numrange[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "numrange[]" -> Bool

PGType "oid" => PGType "oid[]"

Methods

pgTypeName :: PGTypeName "oid[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "oid[]" -> Bool

PGType "oidvector" => PGType "oidvector[]"

Methods

pgTypeName :: PGTypeName "oidvector[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "oidvector[]" -> Bool

PGType "path" => PGType "path[]"

Methods

pgTypeName :: PGTypeName "path[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "path[]" -> Bool

PGType "point" => PGType "point[]"

Methods

pgTypeName :: PGTypeName "point[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "point[]" -> Bool

PGType "polygon" => PGType "polygon[]"

Methods

pgTypeName :: PGTypeName "polygon[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "polygon[]" -> Bool

PGType "real" => PGType "real[]"

Methods

pgTypeName :: PGTypeName "real[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "real[]" -> Bool

PGType "record" => PGType "record[]"

Methods

pgTypeName :: PGTypeName "record[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "record[]" -> Bool

PGType "refcursor" => PGType "refcursor[]"

Methods

pgTypeName :: PGTypeName "refcursor[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "refcursor[]" -> Bool

PGType "regclass" => PGType "regclass[]"

Methods

pgTypeName :: PGTypeName "regclass[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "regclass[]" -> Bool

PGType "regconfig" => PGType "regconfig[]"

Methods

pgTypeName :: PGTypeName "regconfig[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "regconfig[]" -> Bool

PGType "regdictionary" => PGType "regdictionary[]"

Methods

pgTypeName :: PGTypeName "regdictionary[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "regdictionary[]" -> Bool

PGType "regoper" => PGType "regoper[]"

Methods

pgTypeName :: PGTypeName "regoper[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "regoper[]" -> Bool

PGType "regoperator" => PGType "regoperator[]"

Methods

pgTypeName :: PGTypeName "regoperator[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "regoperator[]" -> Bool

PGType "regproc" => PGType "regproc[]"

Methods

pgTypeName :: PGTypeName "regproc[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "regproc[]" -> Bool

PGType "regprocedure" => PGType "regprocedure[]"

Methods

pgTypeName :: PGTypeName "regprocedure[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "regprocedure[]" -> Bool

PGType "regtype" => PGType "regtype[]"

Methods

pgTypeName :: PGTypeName "regtype[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "regtype[]" -> Bool

PGType "reltime" => PGType "reltime[]"

Methods

pgTypeName :: PGTypeName "reltime[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "reltime[]" -> Bool

PGType "smallint" => PGType "smallint[]"

Methods

pgTypeName :: PGTypeName "smallint[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "smallint[]" -> Bool

PGType "text" => PGType "text[]"

Methods

pgTypeName :: PGTypeName "text[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "text[]" -> Bool

PGType "tid" => PGType "tid[]"

Methods

pgTypeName :: PGTypeName "tid[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "tid[]" -> Bool

PGType "time with time zone" => PGType "time with time zone[]"

Methods

pgTypeName :: PGTypeName "time with time zone[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "time with time zone[]" -> Bool

PGType "time without time zone" => PGType "time without time zone[]"

Methods

pgTypeName :: PGTypeName "time without time zone[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "time without time zone[]" -> Bool

PGType "timestamp with time zone" => PGType "timestamp with time zone[]"

Methods

pgTypeName :: PGTypeName "timestamp with time zone[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "timestamp with time zone[]" -> Bool

PGType "timestamp without time zone" => PGType "timestamp without time zone[]"

Methods

pgTypeName :: PGTypeName "timestamp without time zone[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "timestamp without time zone[]" -> Bool

PGType "tinterval" => PGType "tinterval[]"

Methods

pgTypeName :: PGTypeName "tinterval[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "tinterval[]" -> Bool

PGType "tsquery" => PGType "tsquery[]"

Methods

pgTypeName :: PGTypeName "tsquery[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "tsquery[]" -> Bool

PGType "tsrange" => PGType "tsrange[]"

Methods

pgTypeName :: PGTypeName "tsrange[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "tsrange[]" -> Bool

PGType "tstzrange" => PGType "tstzrange[]"

Methods

pgTypeName :: PGTypeName "tstzrange[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "tstzrange[]" -> Bool

PGType "tsvector" => PGType "tsvector[]"

Methods

pgTypeName :: PGTypeName "tsvector[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "tsvector[]" -> Bool

PGType "txid_snapshot" => PGType "txid_snapshot[]"

Methods

pgTypeName :: PGTypeName "txid_snapshot[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "txid_snapshot[]" -> Bool

PGType "uuid" => PGType "uuid[]"

Methods

pgTypeName :: PGTypeName "uuid[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "uuid[]" -> Bool

PGType "varbit" => PGType "varbit[]"

Methods

pgTypeName :: PGTypeName "varbit[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "varbit[]" -> Bool

PGType "xid" => PGType "xid[]"

Methods

pgTypeName :: PGTypeName "xid[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "xid[]" -> Bool

PGType "xml" => PGType "xml[]"

Methods

pgTypeName :: PGTypeName "xml[]" -> String

pgBinaryColumn :: PGTypeEnv -> PGTypeName "xml[]" -> Bool

(PGArrayType ta t, PGColumn t a) => PGColumn ta (PGArray a)

Methods

pgDecode :: PGTypeName ta -> PGTextValue -> PGArray a

pgDecodeBinary :: PGTypeEnv -> PGTypeName ta -> PGBinaryValue -> PGArray a

pgDecodeValue :: PGTypeEnv -> PGTypeName ta -> PGValue -> PGArray a

(PGArrayType ta t, PGParameter t a) => PGParameter ta [a]

Allow entirely non-null arrays as parameter inputs only. (Only supported on ghc >= 7.10 due to instance overlap.)

Methods

pgEncode :: PGTypeName ta -> [a] -> PGTextValue

pgLiteral :: PGTypeName ta -> [a] -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeName ta -> [a] -> PGValue

(PGArrayType ta t, PGParameter t a) => PGParameter ta (PGArray a)

Methods

pgEncode :: PGTypeName ta -> PGArray a -> PGTextValue

pgLiteral :: PGTypeName ta -> PGArray a -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeName ta -> PGArray a -> PGValue