Database.PostgreSQL.Typed.Types

Classes to support type inference, value encoding/decoding, and instances to support built-in PostgreSQL types.

Basic types

type OID = Word32

data PGValue

A value passed to or from PostgreSQL in raw format.

Constructors

PGNullValue

PGTextValue

The standard text encoding format (also used for unknown formats)

Fields

• pgTextValue :: PGTextValue

PGBinaryValue

Special binary-encoded data. Not supported in all cases.

Fields

• pgBinaryValue :: PGBinaryValue

Instances

Eq PGValue

Defined in Database.PostgreSQL.Typed.Types

Methods

(==) :: PGValue -> PGValue -> Bool

(/=) :: PGValue -> PGValue -> Bool

Show PGValue

Defined in Database.PostgreSQL.Typed.Types

Methods

showsPrec :: Int -> PGValue -> ShowS

show :: PGValue -> String

showList :: [PGValue] -> ShowS

PGType t => PGColumn t PGValue

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID t -> PGTextValue -> PGValue

pgDecodeBinary :: PGTypeEnv -> PGTypeID t -> PGBinaryValue -> PGValue

pgDecodeValue :: PGTypeEnv -> PGTypeID t -> PGValue -> PGValue

PGParameter "any" PGValue

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID "any" -> PGValue -> PGTextValue

pgLiteral :: PGTypeID "any" -> PGValue -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID "any" -> PGValue -> PGValue

PGQuery ByteString PGValues

Defined in Database.PostgreSQL.Typed.Query

Methods

pgRunQuery :: PGConnection -> ByteString -> IO (Int, [PGValues])

unsafeModifyQuery :: ByteString -> (ByteString -> ByteString) -> ByteString

getQueryString :: PGTypeEnv -> ByteString -> ByteString

IsString (PGSimpleQuery PGValues)

Defined in Database.PostgreSQL.Typed.Query

Methods

fromString :: String -> PGSimpleQuery PGValues

type PGValues = [PGValue]

A list of (nullable) data values, e.g. a single row or query parameters.

data PGTypeID (t :: Symbol)

A proxy type for PostgreSQL types. The type argument should be an (internal) name of a database type, as per format_type(OID) (usually the same as \dT+). When the type's namespace (schema) is not in search_path, this will be explicitly qualified, so you should be sure to have a consistent search_path for all database connections. The underlying Symbol should be considered a lifted PGName.

Constructors

PGTypeProxy

data PGTypeEnv

Parameters that affect how marshalling happens. Currenly we force all other relevant parameters at connect time. Nothing values represent unknown.

Constructors

PGTypeEnv

Fields

• pgIntegerDatetimes :: Maybe Bool

  If integer_datetimes is on; only relevant for binary encoding.

• pgServerVersion :: Maybe ByteString

  The server_version parameter

Instances

Show PGTypeEnv

Defined in Database.PostgreSQL.Typed.Types

Methods

showsPrec :: Int -> PGTypeEnv -> ShowS

show :: PGTypeEnv -> String

showList :: [PGTypeEnv] -> ShowS

unknownPGTypeEnv :: PGTypeEnv

newtype PGName

A PostgreSQL literal identifier, generally corresponding to the "name" type (63-byte strings), but as it would be entered in a query, so may include double-quoting for special characters or schema-qualification.

Constructors

PGName

Fields

• pgNameBytes :: [Word8]

  Raw bytes of the identifier (should really be a ByteString, but we need a working Data instance for annotations).

Instances

Eq PGName

Defined in Database.PostgreSQL.Typed.Types

Methods

(==) :: PGName -> PGName -> Bool

(/=) :: PGName -> PGName -> Bool

Data PGName

Defined in Database.PostgreSQL.Typed.Types

Methods

gfoldl :: (forall d b. Data d => c (d -> b) -> d -> c b) -> (forall g. g -> c g) -> PGName -> c PGName

gunfold :: (forall b r. Data b => c (b -> r) -> c r) -> (forall r. r -> c r) -> Constr -> c PGName

toConstr :: PGName -> Constr

dataTypeOf :: PGName -> DataType

dataCast1 :: Typeable t => (forall d. Data d => c (t d)) -> Maybe (c PGName)

dataCast2 :: Typeable t => (forall d e. (Data d, Data e) => c (t d e)) -> Maybe (c PGName)

gmapT :: (forall b. Data b => b -> b) -> PGName -> PGName

gmapQl :: (r -> r' -> r) -> r -> (forall d. Data d => d -> r') -> PGName -> r

gmapQr :: (r' -> r -> r) -> r -> (forall d. Data d => d -> r') -> PGName -> r

gmapQ :: (forall d. Data d => d -> u) -> PGName -> [u]

gmapQi :: Int -> (forall d. Data d => d -> u) -> PGName -> u

gmapM :: Monad m => (forall d. Data d => d -> m d) -> PGName -> m PGName

gmapMp :: MonadPlus m => (forall d. Data d => d -> m d) -> PGName -> m PGName

gmapMo :: MonadPlus m => (forall d. Data d => d -> m d) -> PGName -> m PGName

Ord PGName

Defined in Database.PostgreSQL.Typed.Types

Methods

compare :: PGName -> PGName -> Ordering

(<) :: PGName -> PGName -> Bool

(<=) :: PGName -> PGName -> Bool

(>) :: PGName -> PGName -> Bool

(>=) :: PGName -> PGName -> Bool

max :: PGName -> PGName -> PGName

min :: PGName -> PGName -> PGName

Show PGName

Unquoted pgNameString.

Defined in Database.PostgreSQL.Typed.Types

Methods

showsPrec :: Int -> PGName -> ShowS

show :: PGName -> String

showList :: [PGName] -> ShowS

IsString PGName

Applies utf-8 encoding.

Defined in Database.PostgreSQL.Typed.Types

Methods

fromString :: String -> PGName

PGRep PGName

Defined in Database.PostgreSQL.Typed.Dynamic

Associated Types

type PGRepType PGName :: Symbol

PGStringType t => PGColumn t PGName

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID t -> PGTextValue -> PGName

pgDecodeBinary :: PGTypeEnv -> PGTypeID t -> PGBinaryValue -> PGName

pgDecodeValue :: PGTypeEnv -> PGTypeID t -> PGValue -> PGName

PGStringType t => PGParameter t PGName

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID t -> PGName -> PGTextValue

pgLiteral :: PGTypeID t -> PGName -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID t -> PGName -> PGValue

type PGRepType PGName

Defined in Database.PostgreSQL.Typed.Dynamic

type PGRepType PGName = "text"

pgNameBS :: PGName -> ByteString

The literal identifier as used in a query.

pgNameString :: PGName -> String

Reverses the IsString instantce.

newtype PGRecord

Generic class of composite (row or record) types.

Constructors

PGRecord [Maybe PGTextValue]

Instances

PGRecordType t => PGColumn t PGRecord

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID t -> PGTextValue -> PGRecord

pgDecodeBinary :: PGTypeEnv -> PGTypeID t -> PGBinaryValue -> PGRecord

pgDecodeValue :: PGTypeEnv -> PGTypeID t -> PGValue -> PGRecord

PGRecordType t => PGParameter t PGRecord

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID t -> PGRecord -> PGTextValue

pgLiteral :: PGTypeID t -> PGRecord -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID t -> PGRecord -> PGValue

Marshalling classes

class (KnownSymbol t, PGParameter t (PGVal t), PGColumn t (PGVal t)) => PGType t where

A valid PostgreSQL type, its metadata, and corresponding Haskell representation. For conversion the other way (from Haskell type to PostgreSQL), see PGRep. Unfortunately any instances of this will be orphans.

Minimal complete definition

Nothing

Associated Types

type PGVal t :: *

The default, native Haskell representation of this type, which should be as close as possible to the PostgreSQL representation.

Methods

pgTypeName :: PGTypeID t -> PGName

The string name of this type: specialized version of symbolVal.

pgBinaryColumn :: PGTypeEnv -> PGTypeID t -> Bool

Does this type support binary decoding? If so, pgDecodeBinary must be implemented for every PGColumn instance of this type.

Instances

PGType "\"char\""

Defined in Database.PostgreSQL.Typed.Types

Associated Types

type PGVal "\"char\"" :: Type

Methods

pgTypeName :: PGTypeID "\"char\"" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "\"char\"" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "\"char\"[]" :: Type

Methods

pgTypeName :: PGTypeID "\"char\"[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "abstime[]" :: Type

Methods

pgTypeName :: PGTypeID "abstime[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "aclitem[]" :: Type

Methods

pgTypeName :: PGTypeID "aclitem[]" -> PGName

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

PGType "any"

Defined in Database.PostgreSQL.Typed.Types

Associated Types

type PGVal "any" :: Type

Methods

pgTypeName :: PGTypeID "any" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "any" -> Bool

PGType "bigint"

Defined in Database.PostgreSQL.Typed.Types

Associated Types

type PGVal "bigint" :: Type

Methods

pgTypeName :: PGTypeID "bigint" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "bigint" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "bigint[]" :: Type

Methods

pgTypeName :: PGTypeID "bigint[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "bit[]" :: Type

Methods

pgTypeName :: PGTypeID "bit[]" -> PGName

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

PGType "boolean"

Defined in Database.PostgreSQL.Typed.Types

Associated Types

type PGVal "boolean" :: Type

Methods

pgTypeName :: PGTypeID "boolean" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "boolean" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "boolean[]" :: Type

Methods

pgTypeName :: PGTypeID "boolean[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "box[]" :: Type

Methods

pgTypeName :: PGTypeID "box[]" -> PGName

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

PGType "bpchar"

Defined in Database.PostgreSQL.Typed.Types

Associated Types

type PGVal "bpchar" :: Type

Methods

pgTypeName :: PGTypeID "bpchar" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "bpchar" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "bpchar[]" :: Type

Methods

pgTypeName :: PGTypeID "bpchar[]" -> PGName

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

PGType "bytea"

Defined in Database.PostgreSQL.Typed.Types

Associated Types

type PGVal "bytea" :: Type

Methods

pgTypeName :: PGTypeID "bytea" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "bytea" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "bytea[]" :: Type

Methods

pgTypeName :: PGTypeID "bytea[]" -> PGName

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

PGType "character varying"

Defined in Database.PostgreSQL.Typed.Types

Associated Types

type PGVal "character varying" :: Type

Methods

pgTypeName :: PGTypeID "character varying" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "character varying" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "character varying[]" :: Type

Methods

pgTypeName :: PGTypeID "character varying[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "cid[]" :: Type

Methods

pgTypeName :: PGTypeID "cid[]" -> PGName

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

PGType "cidr"

Defined in Database.PostgreSQL.Typed.Inet

Associated Types

type PGVal "cidr" :: Type

Methods

pgTypeName :: PGTypeID "cidr" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "cidr" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "cidr[]" :: Type

Methods

pgTypeName :: PGTypeID "cidr[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "circle[]" :: Type

Methods

pgTypeName :: PGTypeID "circle[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "cstring[]" :: Type

Methods

pgTypeName :: PGTypeID "cstring[]" -> PGName

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

PGType "date"

Defined in Database.PostgreSQL.Typed.Types

Associated Types

type PGVal "date" :: Type

Methods

pgTypeName :: PGTypeID "date" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "date" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "date[]" :: Type

Methods

pgTypeName :: PGTypeID "date[]" -> PGName

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

PGType "daterange"

Defined in Database.PostgreSQL.Typed.Range

Associated Types

type PGVal "daterange" :: Type

Methods

pgTypeName :: PGTypeID "daterange" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "daterange" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "daterange[]" :: Type

Methods

pgTypeName :: PGTypeID "daterange[]" -> PGName

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

PGType "double precision"

Defined in Database.PostgreSQL.Typed.Types

Associated Types

type PGVal "double precision" :: Type

Methods

pgTypeName :: PGTypeID "double precision" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "double precision" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "double precision[]" :: Type

Methods

pgTypeName :: PGTypeID "double precision[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "gtsvector[]" :: Type

Methods

pgTypeName :: PGTypeID "gtsvector[]" -> PGName

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

PGType "inet"

Defined in Database.PostgreSQL.Typed.Inet

Associated Types

type PGVal "inet" :: Type

Methods

pgTypeName :: PGTypeID "inet" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "inet" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "inet[]" :: Type

Methods

pgTypeName :: PGTypeID "inet[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "int2vector[]" :: Type

Methods

pgTypeName :: PGTypeID "int2vector[]" -> PGName

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

PGType "int4range"

Defined in Database.PostgreSQL.Typed.Range

Associated Types

type PGVal "int4range" :: Type

Methods

pgTypeName :: PGTypeID "int4range" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "int4range" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "int4range[]" :: Type

Methods

pgTypeName :: PGTypeID "int4range[]" -> PGName

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

PGType "int8range"

Defined in Database.PostgreSQL.Typed.Range

Associated Types

type PGVal "int8range" :: Type

Methods

pgTypeName :: PGTypeID "int8range" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "int8range" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "int8range[]" :: Type

Methods

pgTypeName :: PGTypeID "int8range[]" -> PGName

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

PGType "integer"

Defined in Database.PostgreSQL.Typed.Types

Associated Types

type PGVal "integer" :: Type

Methods

pgTypeName :: PGTypeID "integer" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "integer" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "integer[]" :: Type

Methods

pgTypeName :: PGTypeID "integer[]" -> PGName

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

PGType "interval"

Defined in Database.PostgreSQL.Typed.Types

Associated Types

type PGVal "interval" :: Type

Methods

pgTypeName :: PGTypeID "interval" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "interval" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "interval[]" :: Type

Methods

pgTypeName :: PGTypeID "interval[]" -> PGName

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

PGType "json"

Defined in Database.PostgreSQL.Typed.Types

Associated Types

type PGVal "json" :: Type

Methods

pgTypeName :: PGTypeID "json" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "json" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "json[]" :: Type

Methods

pgTypeName :: PGTypeID "json[]" -> PGName

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

PGType "jsonb"

Defined in Database.PostgreSQL.Typed.Types

Associated Types

type PGVal "jsonb" :: Type

Methods

pgTypeName :: PGTypeID "jsonb" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "jsonb" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "line[]" :: Type

Methods

pgTypeName :: PGTypeID "line[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "lseg[]" :: Type

Methods

pgTypeName :: PGTypeID "lseg[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "macaddr[]" :: Type

Methods

pgTypeName :: PGTypeID "macaddr[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "money[]" :: Type

Methods

pgTypeName :: PGTypeID "money[]" -> PGName

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

PGType "name"

Defined in Database.PostgreSQL.Typed.Types

Associated Types

type PGVal "name" :: Type

Methods

pgTypeName :: PGTypeID "name" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "name" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "name[]" :: Type

Methods

pgTypeName :: PGTypeID "name[]" -> PGName

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

PGType "numeric"

Defined in Database.PostgreSQL.Typed.Types

Associated Types

type PGVal "numeric" :: Type

Methods

pgTypeName :: PGTypeID "numeric" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "numeric" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "numeric[]" :: Type

Methods

pgTypeName :: PGTypeID "numeric[]" -> PGName

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

PGType "numrange"

Defined in Database.PostgreSQL.Typed.Range

Associated Types

type PGVal "numrange" :: Type

Methods

pgTypeName :: PGTypeID "numrange" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "numrange" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "numrange[]" :: Type

Methods

pgTypeName :: PGTypeID "numrange[]" -> PGName

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

PGType "oid"

Defined in Database.PostgreSQL.Typed.Types

Associated Types

type PGVal "oid" :: Type

Methods

pgTypeName :: PGTypeID "oid" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "oid" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "oid[]" :: Type

Methods

pgTypeName :: PGTypeID "oid[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "oidvector[]" :: Type

Methods

pgTypeName :: PGTypeID "oidvector[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "path[]" :: Type

Methods

pgTypeName :: PGTypeID "path[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "point[]" :: Type

Methods

pgTypeName :: PGTypeID "point[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "polygon[]" :: Type

Methods

pgTypeName :: PGTypeID "polygon[]" -> PGName

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

PGType "real"

Defined in Database.PostgreSQL.Typed.Types

Associated Types

type PGVal "real" :: Type

Methods

pgTypeName :: PGTypeID "real" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "real" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "real[]" :: Type

Methods

pgTypeName :: PGTypeID "real[]" -> PGName

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

PGType "record"

Defined in Database.PostgreSQL.Typed.Types

Associated Types

type PGVal "record" :: Type

Methods

pgTypeName :: PGTypeID "record" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "record" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "record[]" :: Type

Methods

pgTypeName :: PGTypeID "record[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "refcursor[]" :: Type

Methods

pgTypeName :: PGTypeID "refcursor[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "regclass[]" :: Type

Methods

pgTypeName :: PGTypeID "regclass[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "regconfig[]" :: Type

Methods

pgTypeName :: PGTypeID "regconfig[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "regdictionary[]" :: Type

Methods

pgTypeName :: PGTypeID "regdictionary[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "regoper[]" :: Type

Methods

pgTypeName :: PGTypeID "regoper[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "regoperator[]" :: Type

Methods

pgTypeName :: PGTypeID "regoperator[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "regproc[]" :: Type

Methods

pgTypeName :: PGTypeID "regproc[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "regprocedure[]" :: Type

Methods

pgTypeName :: PGTypeID "regprocedure[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "regtype[]" :: Type

Methods

pgTypeName :: PGTypeID "regtype[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "reltime[]" :: Type

Methods

pgTypeName :: PGTypeID "reltime[]" -> PGName

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

PGType "smallint"

Defined in Database.PostgreSQL.Typed.Types

Associated Types

type PGVal "smallint" :: Type

Methods

pgTypeName :: PGTypeID "smallint" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "smallint" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "smallint[]" :: Type

Methods

pgTypeName :: PGTypeID "smallint[]" -> PGName

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

PGType "text"

Defined in Database.PostgreSQL.Typed.Types

Associated Types

type PGVal "text" :: Type

Methods

pgTypeName :: PGTypeID "text" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "text" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "text[]" :: Type

Methods

pgTypeName :: PGTypeID "text[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "tid[]" :: Type

Methods

pgTypeName :: PGTypeID "tid[]" -> PGName

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

PGType "time with time zone"

Defined in Database.PostgreSQL.Typed.Types

Associated Types

type PGVal "time with time zone" :: Type

Methods

pgTypeName :: PGTypeID "time with time zone" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "time with time zone" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "time with time zone[]" :: Type

Methods

pgTypeName :: PGTypeID "time with time zone[]" -> PGName

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

PGType "time without time zone"

Defined in Database.PostgreSQL.Typed.Types

Associated Types

type PGVal "time without time zone" :: Type

Methods

pgTypeName :: PGTypeID "time without time zone" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "time without time zone" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "time without time zone[]" :: Type

Methods

pgTypeName :: PGTypeID "time without time zone[]" -> PGName

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

PGType "timestamp with time zone"

Defined in Database.PostgreSQL.Typed.Types

Associated Types

type PGVal "timestamp with time zone" :: Type

Methods

pgTypeName :: PGTypeID "timestamp with time zone" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "timestamp with time zone" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "timestamp with time zone[]" :: Type

Methods

pgTypeName :: PGTypeID "timestamp with time zone[]" -> PGName

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

PGType "timestamp without time zone"

Defined in Database.PostgreSQL.Typed.Types

Associated Types

type PGVal "timestamp without time zone" :: Type

Methods

pgTypeName :: PGTypeID "timestamp without time zone" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "timestamp without time zone" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "timestamp without time zone[]" :: Type

Methods

pgTypeName :: PGTypeID "timestamp without time zone[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "tinterval[]" :: Type

Methods

pgTypeName :: PGTypeID "tinterval[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "tsquery[]" :: Type

Methods

pgTypeName :: PGTypeID "tsquery[]" -> PGName

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

PGType "tsrange"

Defined in Database.PostgreSQL.Typed.Range

Associated Types

type PGVal "tsrange" :: Type

Methods

pgTypeName :: PGTypeID "tsrange" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "tsrange" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "tsrange[]" :: Type

Methods

pgTypeName :: PGTypeID "tsrange[]" -> PGName

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

PGType "tstzrange"

Defined in Database.PostgreSQL.Typed.Range

Associated Types

type PGVal "tstzrange" :: Type

Methods

pgTypeName :: PGTypeID "tstzrange" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "tstzrange" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "tstzrange[]" :: Type

Methods

pgTypeName :: PGTypeID "tstzrange[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "tsvector[]" :: Type

Methods

pgTypeName :: PGTypeID "tsvector[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "txid_snapshot[]" :: Type

Methods

pgTypeName :: PGTypeID "txid_snapshot[]" -> PGName

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

PGType "uuid"

Defined in Database.PostgreSQL.Typed.Types

Associated Types

type PGVal "uuid" :: Type

Methods

pgTypeName :: PGTypeID "uuid" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "uuid" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "uuid[]" :: Type

Methods

pgTypeName :: PGTypeID "uuid[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "varbit[]" :: Type

Methods

pgTypeName :: PGTypeID "varbit[]" -> PGName

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

PGType "void"

Defined in Database.PostgreSQL.Typed.Types

Associated Types

type PGVal "void" :: Type

Methods

pgTypeName :: PGTypeID "void" -> PGName

pgBinaryColumn :: PGTypeEnv -> PGTypeID "void" -> Bool

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "xid[]" :: Type

Methods

pgTypeName :: PGTypeID "xid[]" -> PGName

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

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

Defined in Database.PostgreSQL.Typed.Array

Associated Types

type PGVal "xml[]" :: Type

Methods

pgTypeName :: PGTypeID "xml[]" -> PGName

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

class PGType t => PGParameter t a where

A PGParameter t a instance describes how to encode a PostgreSQL type t from a.

Minimal complete definition

pgEncode

Methods

pgEncode :: PGTypeID t -> a -> PGTextValue

Encode a value to a PostgreSQL text representation.

pgLiteral :: PGTypeID t -> a -> ByteString

Encode a value to a (quoted) literal value for use in SQL statements. Defaults to a quoted version of pgEncode

pgEncodeValue :: PGTypeEnv -> PGTypeID t -> a -> PGValue

Encode a value to a PostgreSQL representation. Defaults to the text representation by pgEncode

Instances

PGRecordType t => PGParameter t PGRecord

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID t -> PGRecord -> PGTextValue

pgLiteral :: PGTypeID t -> PGRecord -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID t -> PGRecord -> PGValue

PGStringType t => PGParameter t Text

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID t -> Text -> PGTextValue

pgLiteral :: PGTypeID t -> Text -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID t -> Text -> PGValue

PGStringType t => PGParameter t Text

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID t -> Text -> PGTextValue

pgLiteral :: PGTypeID t -> Text -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID t -> Text -> PGValue

PGStringType t => PGParameter t ByteString

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID t -> ByteString -> PGTextValue

pgLiteral :: PGTypeID t -> ByteString -> ByteString0

pgEncodeValue :: PGTypeEnv -> PGTypeID t -> ByteString -> PGValue

PGStringType t => PGParameter t PGName

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID t -> PGName -> PGTextValue

pgLiteral :: PGTypeID t -> PGName -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID t -> PGName -> PGValue

PGStringType t => PGParameter t ByteString

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID t -> ByteString -> PGTextValue

pgLiteral :: PGTypeID t -> ByteString -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID t -> ByteString -> PGValue

PGStringType t => PGParameter t String

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID t -> String -> PGTextValue

pgLiteral :: PGTypeID t -> String -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID t -> String -> PGValue

PGParameter "\"char\"" Char

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID "\"char\"" -> Char -> PGTextValue

pgLiteral :: PGTypeID "\"char\"" -> Char -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID "\"char\"" -> Char -> PGValue

PGParameter "\"char\"" Word8

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID "\"char\"" -> Word8 -> PGTextValue

pgLiteral :: PGTypeID "\"char\"" -> Word8 -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID "\"char\"" -> Word8 -> PGValue

PGParameter "any" PGValue

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID "any" -> PGValue -> PGTextValue

pgLiteral :: PGTypeID "any" -> PGValue -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID "any" -> PGValue -> PGValue

PGParameter "bigint" Int64

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID "bigint" -> Int64 -> PGTextValue

pgLiteral :: PGTypeID "bigint" -> Int64 -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID "bigint" -> Int64 -> PGValue

PGParameter "boolean" Bool

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID "boolean" -> Bool -> PGTextValue

pgLiteral :: PGTypeID "boolean" -> Bool -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID "boolean" -> Bool -> PGValue

PGParameter "bytea" ByteString

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID "bytea" -> ByteString -> PGTextValue

pgLiteral :: PGTypeID "bytea" -> ByteString -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID "bytea" -> ByteString -> PGValue

PGParameter "bytea" ByteString

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID "bytea" -> ByteString -> PGTextValue

pgLiteral :: PGTypeID "bytea" -> ByteString -> ByteString0

pgEncodeValue :: PGTypeEnv -> PGTypeID "bytea" -> ByteString -> PGValue

PGParameter "cidr" PGInet

Defined in Database.PostgreSQL.Typed.Inet

Methods

pgEncode :: PGTypeID "cidr" -> PGInet -> PGTextValue

pgLiteral :: PGTypeID "cidr" -> PGInet -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID "cidr" -> PGInet -> PGValue

PGParameter "date" Day

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID "date" -> Day -> PGTextValue

pgLiteral :: PGTypeID "date" -> Day -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID "date" -> Day -> PGValue

PGParameter "double precision" Double

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID "double precision" -> Double -> PGTextValue

pgLiteral :: PGTypeID "double precision" -> Double -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID "double precision" -> Double -> PGValue

PGParameter "double precision" Float

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID "double precision" -> Float -> PGTextValue

pgLiteral :: PGTypeID "double precision" -> Float -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID "double precision" -> Float -> PGValue

PGParameter "inet" PGInet

Defined in Database.PostgreSQL.Typed.Inet

Methods

pgEncode :: PGTypeID "inet" -> PGInet -> PGTextValue

pgLiteral :: PGTypeID "inet" -> PGInet -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID "inet" -> PGInet -> PGValue

PGParameter "integer" Int32

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID "integer" -> Int32 -> PGTextValue

pgLiteral :: PGTypeID "integer" -> Int32 -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID "integer" -> Int32 -> PGValue

PGParameter "interval" DiffTime

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID "interval" -> DiffTime -> PGTextValue

pgLiteral :: PGTypeID "interval" -> DiffTime -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID "interval" -> DiffTime -> PGValue

PGParameter "json" Value

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID "json" -> Value -> PGTextValue

pgLiteral :: PGTypeID "json" -> Value -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID "json" -> Value -> PGValue

PGParameter "jsonb" Value

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID "jsonb" -> Value -> PGTextValue

pgLiteral :: PGTypeID "jsonb" -> Value -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID "jsonb" -> Value -> PGValue

PGParameter "numeric" Rational

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID "numeric" -> Rational -> PGTextValue

pgLiteral :: PGTypeID "numeric" -> Rational -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID "numeric" -> Rational -> PGValue

PGParameter "numeric" Scientific

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID "numeric" -> Scientific -> PGTextValue

pgLiteral :: PGTypeID "numeric" -> Scientific -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID "numeric" -> Scientific -> PGValue

PGParameter "oid" OID

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID "oid" -> OID -> PGTextValue

pgLiteral :: PGTypeID "oid" -> OID -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID "oid" -> OID -> PGValue

PGParameter "real" Float

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID "real" -> Float -> PGTextValue

pgLiteral :: PGTypeID "real" -> Float -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID "real" -> Float -> PGValue

PGParameter "smallint" Int16

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID "smallint" -> Int16 -> PGTextValue

pgLiteral :: PGTypeID "smallint" -> Int16 -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID "smallint" -> Int16 -> PGValue

PGParameter "time without time zone" TimeOfDay

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID "time without time zone" -> TimeOfDay -> PGTextValue

pgLiteral :: PGTypeID "time without time zone" -> TimeOfDay -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID "time without time zone" -> TimeOfDay -> PGValue

PGParameter "timestamp with time zone" UTCTime

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID "timestamp with time zone" -> UTCTime -> PGTextValue

pgLiteral :: PGTypeID "timestamp with time zone" -> UTCTime -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID "timestamp with time zone" -> UTCTime -> PGValue

PGParameter "timestamp without time zone" LocalTime

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID "timestamp without time zone" -> LocalTime -> PGTextValue

pgLiteral :: PGTypeID "timestamp without time zone" -> LocalTime -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID "timestamp without time zone" -> LocalTime -> PGValue

PGParameter "uuid" UUID

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID "uuid" -> UUID -> PGTextValue

pgLiteral :: PGTypeID "uuid" -> UUID -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID "uuid" -> UUID -> PGValue

PGParameter "void" ()

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID "void" -> () -> PGTextValue

pgLiteral :: PGTypeID "void" -> () -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID "void" -> () -> PGValue

PGParameter t a => PGParameter t (Maybe a)

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID t -> Maybe a -> PGTextValue

pgLiteral :: PGTypeID t -> Maybe a -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID t -> Maybe a -> PGValue

(PGRangeType t, PGParameter (PGSubType t) a) => PGParameter t (Range a)

Defined in Database.PostgreSQL.Typed.Range

Methods

pgEncode :: PGTypeID t -> Range a -> PGTextValue

pgLiteral :: PGTypeID t -> Range a -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID t -> Range a -> PGValue

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

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

Defined in Database.PostgreSQL.Typed.Array

Methods

pgEncode :: PGTypeID t -> [a] -> PGTextValue

pgLiteral :: PGTypeID t -> [a] -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID t -> [a] -> PGValue

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

Defined in Database.PostgreSQL.Typed.Array

Methods

pgEncode :: PGTypeID t -> PGArray a -> PGTextValue

pgLiteral :: PGTypeID t -> PGArray a -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID t -> PGArray a -> PGValue

PGParameter "time with time zone" (TimeOfDay, TimeZone)

Defined in Database.PostgreSQL.Typed.Types

Methods

pgEncode :: PGTypeID "time with time zone" -> (TimeOfDay, TimeZone) -> PGTextValue

pgLiteral :: PGTypeID "time with time zone" -> (TimeOfDay, TimeZone) -> ByteString

pgEncodeValue :: PGTypeEnv -> PGTypeID "time with time zone" -> (TimeOfDay, TimeZone) -> PGValue

class PGType t => PGColumn t a where

A PGColumn t a instance describes how te decode a PostgreSQL type t to a.

Minimal complete definition

pgDecode

Methods

pgDecode :: PGTypeID t -> PGTextValue -> a

Decode the PostgreSQL text representation into a value.

pgDecodeBinary :: PGTypeEnv -> PGTypeID t -> PGBinaryValue -> a

Decode the PostgreSQL binary representation into a value. Only needs to be implemented if pgBinaryColumn is true.

pgDecodeValue :: PGTypeEnv -> PGTypeID t -> PGValue -> a

Instances

PGRecordType t => PGColumn t PGRecord

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID t -> PGTextValue -> PGRecord

pgDecodeBinary :: PGTypeEnv -> PGTypeID t -> PGBinaryValue -> PGRecord

pgDecodeValue :: PGTypeEnv -> PGTypeID t -> PGValue -> PGRecord

PGStringType t => PGColumn t Text

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID t -> PGTextValue -> Text

pgDecodeBinary :: PGTypeEnv -> PGTypeID t -> PGBinaryValue -> Text

pgDecodeValue :: PGTypeEnv -> PGTypeID t -> PGValue -> Text

PGStringType t => PGColumn t Text

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID t -> PGTextValue -> Text

pgDecodeBinary :: PGTypeEnv -> PGTypeID t -> PGBinaryValue -> Text

pgDecodeValue :: PGTypeEnv -> PGTypeID t -> PGValue -> Text

PGStringType t => PGColumn t ByteString

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID t -> PGTextValue -> ByteString

pgDecodeBinary :: PGTypeEnv -> PGTypeID t -> PGBinaryValue -> ByteString

pgDecodeValue :: PGTypeEnv -> PGTypeID t -> PGValue -> ByteString

PGStringType t => PGColumn t PGName

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID t -> PGTextValue -> PGName

pgDecodeBinary :: PGTypeEnv -> PGTypeID t -> PGBinaryValue -> PGName

pgDecodeValue :: PGTypeEnv -> PGTypeID t -> PGValue -> PGName

PGStringType t => PGColumn t ByteString

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID t -> PGTextValue -> ByteString

pgDecodeBinary :: PGTypeEnv -> PGTypeID t -> PGBinaryValue -> ByteString

pgDecodeValue :: PGTypeEnv -> PGTypeID t -> PGValue -> ByteString

PGStringType t => PGColumn t String

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID t -> PGTextValue -> String

pgDecodeBinary :: PGTypeEnv -> PGTypeID t -> PGBinaryValue -> String

pgDecodeValue :: PGTypeEnv -> PGTypeID t -> PGValue -> String

PGType t => PGColumn t PGValue

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID t -> PGTextValue -> PGValue

pgDecodeBinary :: PGTypeEnv -> PGTypeID t -> PGBinaryValue -> PGValue

pgDecodeValue :: PGTypeEnv -> PGTypeID t -> PGValue -> PGValue

PGColumn "\"char\"" Char

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID "\"char\"" -> PGTextValue -> Char

pgDecodeBinary :: PGTypeEnv -> PGTypeID "\"char\"" -> PGBinaryValue -> Char

pgDecodeValue :: PGTypeEnv -> PGTypeID "\"char\"" -> PGValue -> Char

PGColumn "\"char\"" Word8

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID "\"char\"" -> PGTextValue -> Word8

pgDecodeBinary :: PGTypeEnv -> PGTypeID "\"char\"" -> PGBinaryValue -> Word8

pgDecodeValue :: PGTypeEnv -> PGTypeID "\"char\"" -> PGValue -> Word8

PGColumn "bigint" Int64

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID "bigint" -> PGTextValue -> Int64

pgDecodeBinary :: PGTypeEnv -> PGTypeID "bigint" -> PGBinaryValue -> Int64

pgDecodeValue :: PGTypeEnv -> PGTypeID "bigint" -> PGValue -> Int64

PGColumn "boolean" Bool

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID "boolean" -> PGTextValue -> Bool

pgDecodeBinary :: PGTypeEnv -> PGTypeID "boolean" -> PGBinaryValue -> Bool

pgDecodeValue :: PGTypeEnv -> PGTypeID "boolean" -> PGValue -> Bool

PGColumn "bytea" ByteString

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID "bytea" -> PGTextValue -> ByteString

pgDecodeBinary :: PGTypeEnv -> PGTypeID "bytea" -> PGBinaryValue -> ByteString

pgDecodeValue :: PGTypeEnv -> PGTypeID "bytea" -> PGValue -> ByteString

PGColumn "bytea" ByteString

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID "bytea" -> PGTextValue -> ByteString

pgDecodeBinary :: PGTypeEnv -> PGTypeID "bytea" -> PGBinaryValue -> ByteString

pgDecodeValue :: PGTypeEnv -> PGTypeID "bytea" -> PGValue -> ByteString

PGColumn "cidr" PGInet

Defined in Database.PostgreSQL.Typed.Inet

Methods

pgDecode :: PGTypeID "cidr" -> PGTextValue -> PGInet

pgDecodeBinary :: PGTypeEnv -> PGTypeID "cidr" -> PGBinaryValue -> PGInet

pgDecodeValue :: PGTypeEnv -> PGTypeID "cidr" -> PGValue -> PGInet

PGColumn "date" Day

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID "date" -> PGTextValue -> Day

pgDecodeBinary :: PGTypeEnv -> PGTypeID "date" -> PGBinaryValue -> Day

pgDecodeValue :: PGTypeEnv -> PGTypeID "date" -> PGValue -> Day

PGColumn "double precision" Double

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID "double precision" -> PGTextValue -> Double

pgDecodeBinary :: PGTypeEnv -> PGTypeID "double precision" -> PGBinaryValue -> Double

pgDecodeValue :: PGTypeEnv -> PGTypeID "double precision" -> PGValue -> Double

PGColumn "inet" PGInet

Defined in Database.PostgreSQL.Typed.Inet

Methods

pgDecode :: PGTypeID "inet" -> PGTextValue -> PGInet

pgDecodeBinary :: PGTypeEnv -> PGTypeID "inet" -> PGBinaryValue -> PGInet

pgDecodeValue :: PGTypeEnv -> PGTypeID "inet" -> PGValue -> PGInet

PGColumn "integer" Int32

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID "integer" -> PGTextValue -> Int32

pgDecodeBinary :: PGTypeEnv -> PGTypeID "integer" -> PGBinaryValue -> Int32

pgDecodeValue :: PGTypeEnv -> PGTypeID "integer" -> PGValue -> Int32

PGColumn "interval" DiffTime

Representation of DiffTime as interval. PostgreSQL stores months and days separately in intervals, but DiffTime does not. We collapse all interval fields into seconds

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID "interval" -> PGTextValue -> DiffTime

pgDecodeBinary :: PGTypeEnv -> PGTypeID "interval" -> PGBinaryValue -> DiffTime

pgDecodeValue :: PGTypeEnv -> PGTypeID "interval" -> PGValue -> DiffTime

PGColumn "json" Value

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID "json" -> PGTextValue -> Value

pgDecodeBinary :: PGTypeEnv -> PGTypeID "json" -> PGBinaryValue -> Value

pgDecodeValue :: PGTypeEnv -> PGTypeID "json" -> PGValue -> Value

PGColumn "jsonb" Value

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID "jsonb" -> PGTextValue -> Value

pgDecodeBinary :: PGTypeEnv -> PGTypeID "jsonb" -> PGBinaryValue -> Value

pgDecodeValue :: PGTypeEnv -> PGTypeID "jsonb" -> PGValue -> Value

PGColumn "numeric" Rational

High-precision representation of Rational as numeric. Unfortunately, numeric has an NaN, while Rational does not. NaN numeric values will produce exceptions.

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID "numeric" -> PGTextValue -> Rational

pgDecodeBinary :: PGTypeEnv -> PGTypeID "numeric" -> PGBinaryValue -> Rational

pgDecodeValue :: PGTypeEnv -> PGTypeID "numeric" -> PGValue -> Rational

PGColumn "numeric" Scientific

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID "numeric" -> PGTextValue -> Scientific

pgDecodeBinary :: PGTypeEnv -> PGTypeID "numeric" -> PGBinaryValue -> Scientific

pgDecodeValue :: PGTypeEnv -> PGTypeID "numeric" -> PGValue -> Scientific

PGColumn "oid" OID

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID "oid" -> PGTextValue -> OID

pgDecodeBinary :: PGTypeEnv -> PGTypeID "oid" -> PGBinaryValue -> OID

pgDecodeValue :: PGTypeEnv -> PGTypeID "oid" -> PGValue -> OID

PGColumn "real" Double

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID "real" -> PGTextValue -> Double

pgDecodeBinary :: PGTypeEnv -> PGTypeID "real" -> PGBinaryValue -> Double

pgDecodeValue :: PGTypeEnv -> PGTypeID "real" -> PGValue -> Double

PGColumn "real" Float

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID "real" -> PGTextValue -> Float

pgDecodeBinary :: PGTypeEnv -> PGTypeID "real" -> PGBinaryValue -> Float

pgDecodeValue :: PGTypeEnv -> PGTypeID "real" -> PGValue -> Float

PGColumn "smallint" Int16

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID "smallint" -> PGTextValue -> Int16

pgDecodeBinary :: PGTypeEnv -> PGTypeID "smallint" -> PGBinaryValue -> Int16

pgDecodeValue :: PGTypeEnv -> PGTypeID "smallint" -> PGValue -> Int16

PGColumn "time without time zone" TimeOfDay

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID "time without time zone" -> PGTextValue -> TimeOfDay

pgDecodeBinary :: PGTypeEnv -> PGTypeID "time without time zone" -> PGBinaryValue -> TimeOfDay

pgDecodeValue :: PGTypeEnv -> PGTypeID "time without time zone" -> PGValue -> TimeOfDay

PGColumn "timestamp with time zone" UTCTime

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID "timestamp with time zone" -> PGTextValue -> UTCTime

pgDecodeBinary :: PGTypeEnv -> PGTypeID "timestamp with time zone" -> PGBinaryValue -> UTCTime

pgDecodeValue :: PGTypeEnv -> PGTypeID "timestamp with time zone" -> PGValue -> UTCTime

PGColumn "timestamp without time zone" LocalTime

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID "timestamp without time zone" -> PGTextValue -> LocalTime

pgDecodeBinary :: PGTypeEnv -> PGTypeID "timestamp without time zone" -> PGBinaryValue -> LocalTime

pgDecodeValue :: PGTypeEnv -> PGTypeID "timestamp without time zone" -> PGValue -> LocalTime

PGColumn "uuid" UUID

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID "uuid" -> PGTextValue -> UUID

pgDecodeBinary :: PGTypeEnv -> PGTypeID "uuid" -> PGBinaryValue -> UUID

pgDecodeValue :: PGTypeEnv -> PGTypeID "uuid" -> PGValue -> UUID

PGColumn "void" ()

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID "void" -> PGTextValue -> ()

pgDecodeBinary :: PGTypeEnv -> PGTypeID "void" -> PGBinaryValue -> ()

pgDecodeValue :: PGTypeEnv -> PGTypeID "void" -> PGValue -> ()

PGColumn t a => PGColumn t (Maybe a)

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID t -> PGTextValue -> Maybe a

pgDecodeBinary :: PGTypeEnv -> PGTypeID t -> PGBinaryValue -> Maybe a

pgDecodeValue :: PGTypeEnv -> PGTypeID t -> PGValue -> Maybe a

(PGRangeType t, PGColumn (PGSubType t) a) => PGColumn t (Range a)

Defined in Database.PostgreSQL.Typed.Range

Methods

pgDecode :: PGTypeID t -> PGTextValue -> Range a

pgDecodeBinary :: PGTypeEnv -> PGTypeID t -> PGBinaryValue -> Range a

pgDecodeValue :: PGTypeEnv -> PGTypeID t -> PGValue -> Range a

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

Defined in Database.PostgreSQL.Typed.Array

Methods

pgDecode :: PGTypeID t -> PGTextValue -> PGArray a

pgDecodeBinary :: PGTypeEnv -> PGTypeID t -> PGBinaryValue -> PGArray a

pgDecodeValue :: PGTypeEnv -> PGTypeID t -> PGValue -> PGArray a

PGColumn "time with time zone" (TimeOfDay, TimeZone)

Defined in Database.PostgreSQL.Typed.Types

Methods

pgDecode :: PGTypeID "time with time zone" -> PGTextValue -> (TimeOfDay, TimeZone)

pgDecodeBinary :: PGTypeEnv -> PGTypeID "time with time zone" -> PGBinaryValue -> (TimeOfDay, TimeZone)

pgDecodeValue :: PGTypeEnv -> PGTypeID "time with time zone" -> PGValue -> (TimeOfDay, TimeZone)

class PGType t => PGStringType t

Instances

PGStringType "bpchar"

Defined in Database.PostgreSQL.Typed.Types

PGStringType "character varying"

Defined in Database.PostgreSQL.Typed.Types

PGStringType "name"

Defined in Database.PostgreSQL.Typed.Types

PGStringType "text"

Defined in Database.PostgreSQL.Typed.Types

class PGType t => PGRecordType t

Instances

PGRecordType "record"

The generic anonymous record type, as created by ROW. In this case we can not know the types, and in fact, PostgreSQL does not accept values of this type regardless (except as literals).

Defined in Database.PostgreSQL.Typed.Types

Marshalling interface

pgEncodeParameter :: PGParameter t a => PGTypeEnv -> PGTypeID t -> a -> PGValue

Final parameter encoding function used when a (nullable) parameter is passed to a prepared query.

pgEscapeParameter :: PGParameter t a => PGTypeEnv -> PGTypeID t -> a -> ByteString

Final parameter escaping function used when a (nullable) parameter is passed to be substituted into a simple query.

pgDecodeColumn :: PGColumn t (Maybe a) => PGTypeEnv -> PGTypeID t -> PGValue -> Maybe a

Final column decoding function used for a nullable result value.

pgDecodeColumnNotNull :: PGColumn t a => PGTypeEnv -> PGTypeID t -> PGValue -> a

Final column decoding function used for a non-nullable result value.

Conversion utilities

pgQuote :: ByteString -> ByteString

Produce a SQL string literal by wrapping (and escaping) a string with single quotes.

pgDQuote :: ByteString -> Builder

Double-quote a value (e.g., as an identifier). Does not properly handle unicode escaping (yet).

pgDQuoteFrom :: [Char] -> ByteString -> Builder

Double-quote a value if it's "", "null", or contains any whitespace, '"', '\', or the characters given in the first argument.

parsePGDQuote :: Bool -> [Char] -> (ByteString -> Bool) -> Parser (Maybe ByteString)

Parse double-quoted values ala pgDQuote.

buildPGValue :: Builder -> ByteString

Shorthand for toStrict . toLazyByteString