Database.PostgreSQL.PQTypes.Model.Index

Documentation

data TableIndex

Constructors

TableIndex

Fields

• idxColumns :: [RawSQL ()]
• idxMethod :: IndexMethod
• idxUnique :: Bool
• idxWhere :: Maybe (RawSQL ())

Instances

Eq TableIndex

Methods

(==) :: TableIndex -> TableIndex -> Bool

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

Ord TableIndex

Methods

compare :: TableIndex -> TableIndex -> Ordering

(<) :: TableIndex -> TableIndex -> Bool

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

(>) :: TableIndex -> TableIndex -> Bool

(>=) :: TableIndex -> TableIndex -> Bool

max :: TableIndex -> TableIndex -> TableIndex

min :: TableIndex -> TableIndex -> TableIndex

Show TableIndex

Methods

showsPrec :: Int -> TableIndex -> ShowS

show :: TableIndex -> String

showList :: [TableIndex] -> ShowS

data IndexMethod

Constructors

BTree

GIN

Instances

Eq IndexMethod

Methods

(==) :: IndexMethod -> IndexMethod -> Bool

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

Ord IndexMethod

Methods

compare :: IndexMethod -> IndexMethod -> Ordering

(<) :: IndexMethod -> IndexMethod -> Bool

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

(>) :: IndexMethod -> IndexMethod -> Bool

(>=) :: IndexMethod -> IndexMethod -> Bool

max :: IndexMethod -> IndexMethod -> IndexMethod

min :: IndexMethod -> IndexMethod -> IndexMethod

Read IndexMethod

Methods

readsPrec :: Int -> ReadS IndexMethod

readList :: ReadS [IndexMethod]

readPrec :: ReadPrec IndexMethod

readListPrec :: ReadPrec [IndexMethod]

Show IndexMethod

Methods

showsPrec :: Int -> IndexMethod -> ShowS

show :: IndexMethod -> String

showList :: [IndexMethod] -> ShowS

tblIndex :: TableIndex

indexOnColumn :: RawSQL () -> TableIndex

indexOnColumns :: [RawSQL ()] -> TableIndex

indexOnColumnWithMethod :: RawSQL () -> IndexMethod -> TableIndex

Create an index on the given column with the specified method. No checks are made that the method is appropriate for the type of the column.

indexOnColumnsWithMethod :: [RawSQL ()] -> IndexMethod -> TableIndex

Create an index on the given columns with the specified method. No checks are made that the method is appropriate for the type of the column; cf. the PostgreSQL manual.

uniqueIndexOnColumn :: RawSQL () -> TableIndex

uniqueIndexOnColumnWithCondition :: RawSQL () -> RawSQL () -> TableIndex

uniqueIndexOnColumns :: [RawSQL ()] -> TableIndex

indexName :: RawSQL () -> TableIndex -> RawSQL ()

sqlCreateIndex :: RawSQL () -> TableIndex -> RawSQL ()

sqlDropIndex :: RawSQL () -> TableIndex -> RawSQL ()