Squeal.PostgreSQL.Session.Oid

Object identifiers are used internally by PostgreSQL as primary keys. They are needed to correctly encode statement parameters.

Oids

data Oid

Instances

Eq Oid

Defined in Database.PostgreSQL.LibPQ

Methods

(==) :: Oid -> Oid -> Bool

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

Ord Oid

Defined in Database.PostgreSQL.LibPQ

Methods

compare :: Oid -> Oid -> Ordering

(<) :: Oid -> Oid -> Bool

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

(>) :: Oid -> Oid -> Bool

(>=) :: Oid -> Oid -> Bool

max :: Oid -> Oid -> Oid

min :: Oid -> Oid -> Oid

Read Oid

Defined in Database.PostgreSQL.LibPQ

Methods

readsPrec :: Int -> ReadS Oid

readList :: ReadS [Oid]

readPrec :: ReadPrec Oid

readListPrec :: ReadPrec [Oid]

Show Oid

Defined in Database.PostgreSQL.LibPQ

Methods

showsPrec :: Int -> Oid -> ShowS

show :: Oid -> String

showList :: [Oid] -> ShowS

Storable Oid

Defined in Database.PostgreSQL.LibPQ

Methods

sizeOf :: Oid -> Int

alignment :: Oid -> Int

peekElemOff :: Ptr Oid -> Int -> IO Oid

pokeElemOff :: Ptr Oid -> Int -> Oid -> IO ()

peekByteOff :: Ptr b -> Int -> IO Oid

pokeByteOff :: Ptr b -> Int -> Oid -> IO ()

peek :: Ptr Oid -> IO Oid

poke :: Ptr Oid -> Oid -> IO ()

IsPG Oid

PGint2

Defined in Squeal.PostgreSQL.Type.PG

Associated Types

type PG Oid :: PGType

FromPG Oid

Defined in Squeal.PostgreSQL.Session.Decode

Methods

fromPG :: StateT ByteString (Except Text) Oid

Inline Oid

Defined in Squeal.PostgreSQL.Expression.Inline

Methods

inline :: forall (null :: PGType -> NullType). Oid -> Expr (null (PG Oid))

ToPG db Oid

Defined in Squeal.PostgreSQL.Session.Encode

Methods

toPG :: Oid -> ReaderT (K Connection db) IO Encoding

type PG Oid

Defined in Squeal.PostgreSQL.Type.PG

type PG Oid = 'PGoid

class OidOf (db :: SchemasType) (pg :: PGType) where

The Oid of a PGType

>>> :set -XTypeApplications
>>> conn <- connectdb @'[] "host=localhost port=5432 dbname=exampledb user=postgres password=postgres"
>>> runReaderT (oidOf @'[] @'PGbool) conn
Oid 16

>>> finish conn

Methods

oidOf :: ReaderT (K Connection db) IO Oid

Instances

OidOf db 'PGoid

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOf db 'PGtsquery

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOf db 'PGtsvector

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOf db 'PGjsonb

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOf db 'PGjson

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOf db 'PGinet

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOf db 'PGuuid

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOf db 'PGinterval

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOf db 'PGtimetz

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOf db 'PGtime

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOf db 'PGdate

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOf db 'PGtimestamptz

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOf db 'PGtimestamp

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOf db 'PGbytea

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOf db 'PGtext

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOf db 'PGmoney

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOf db 'PGfloat8

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOf db 'PGfloat4

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOf db 'PGnumeric

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOf db 'PGint8

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOf db 'PGint4

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOf db 'PGint2

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOf db 'PGbool

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

(enums ~ DbEnums db, FindQualified "no enum found with labels:" enums labels ~ '(sch, td), KnownSymbol sch, KnownSymbol td) => OidOf db ('PGenum labels)

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

(KnownSymbol sch, KnownSymbol td, rels ~ DbRelations db, FindQualified "no relation found with row:" rels row ~ '(sch, td)) => OidOf db ('PGcomposite row)

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOf db ('PGrange 'PGdate)

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOf db ('PGrange 'PGtimestamptz)

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOf db ('PGrange 'PGtimestamp)

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOf db ('PGrange 'PGnumeric)

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOf db ('PGrange 'PGint8)

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOf db ('PGrange 'PGint4)

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOf db ('PGvarchar n)

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOf db ('PGchar n)

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOfArray db pg => OidOf db ('PGvararray (null pg))

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

OidOfArray db pg => OidOf db ('PGfixarray dims (null pg))

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOf :: ReaderT (K Connection db) IO Oid

class OidOfArray (db :: SchemasType) (pg :: PGType) where

The Oid of an array

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

Instances

OidOfArray db 'PGoid

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

OidOfArray db 'PGtsquery

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

OidOfArray db 'PGtsvector

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

OidOfArray db 'PGjsonb

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

OidOfArray db 'PGjson

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

OidOfArray db 'PGinet

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

OidOfArray db 'PGuuid

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

OidOfArray db 'PGinterval

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

OidOfArray db 'PGtimetz

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

OidOfArray db 'PGtime

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

OidOfArray db 'PGdate

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

OidOfArray db 'PGtimestamptz

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

OidOfArray db 'PGtimestamp

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

OidOfArray db 'PGbytea

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

OidOfArray db 'PGtext

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

OidOfArray db 'PGmoney

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

OidOfArray db 'PGfloat8

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

OidOfArray db 'PGfloat4

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

OidOfArray db 'PGnumeric

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

OidOfArray db 'PGint8

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

OidOfArray db 'PGint4

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

OidOfArray db 'PGint2

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

OidOfArray db 'PGbool

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

(enums ~ DbEnums db, FindQualified "no enum found with labels:" enums labels ~ '(sch, td), KnownSymbol sch, KnownSymbol td) => OidOfArray db ('PGenum labels)

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

(KnownSymbol sch, KnownSymbol td, rels ~ DbRelations db, FindQualified "no relation found with row:" rels row ~ '(sch, td)) => OidOfArray db ('PGcomposite row)

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

OidOfArray db ('PGrange 'PGdate)

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

OidOfArray db ('PGrange 'PGtimestamptz)

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

OidOfArray db ('PGrange 'PGtimestamp)

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

OidOfArray db ('PGrange 'PGnumeric)

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

OidOfArray db ('PGrange 'PGint8)

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

OidOfArray db ('PGrange 'PGint4)

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

OidOfArray db ('PGvarchar n)

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

OidOfArray db ('PGchar n)

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfArray :: ReaderT (K Connection db) IO Oid

class OidOfNull (db :: SchemasType) (ty :: NullType) where

The Oid of a NullType

Methods

oidOfNull :: ReaderT (K Connection db) IO Oid

Instances

OidOf db pg => OidOfNull db (null pg)

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfNull :: ReaderT (K Connection db) IO Oid

class OidOfField (db :: SchemasType) (field :: (Symbol, NullType)) where

The Oid of a field

Methods

oidOfField :: ReaderT (K Connection db) IO Oid

Instances

OidOfNull db ty => OidOfField db (fld ::: ty)

Defined in Squeal.PostgreSQL.Session.Oid

Methods

oidOfField :: ReaderT (K Connection db) IO Oid