Safe Haskell | None |
---|---|
Language | Haskell98 |
See detailed documentation for PostgreSQL arrays at http://www.postgresql.org/docs/9.2/static/arrays.html and http://www.postgresql.org/docs/9.2/static/functions-array.html
Synopsis
- newtype Array a = Array [a]
- (!) :: (ExpressionOf Postgresql r a (Array elem), ExpressionOf Postgresql r b Int) => a -> b -> Expr Postgresql r elem
- (!:) :: (ExpressionOf Postgresql r a (Array elem), ExpressionOf Postgresql r i1 Int, ExpressionOf Postgresql r i2 Int) => a -> (i1, i2) -> Expr Postgresql r (Array elem)
- append :: (ExpressionOf Postgresql r a (Array elem), ExpressionOf Postgresql r b elem) => a -> b -> Expr Postgresql r (Array elem)
- prepend :: (ExpressionOf Postgresql r a elem, ExpressionOf Postgresql r b (Array elem)) => a -> b -> Expr Postgresql r (Array elem)
- arrayCat :: (ExpressionOf Postgresql r a (Array elem), ExpressionOf Postgresql r b (Array elem)) => a -> b -> Expr Postgresql r (Array elem)
- arrayDims :: ExpressionOf Postgresql r a (Array elem) => a -> Expr Postgresql r String
- arrayNDims :: ExpressionOf Postgresql r a (Array elem) => a -> Expr Postgresql r Int
- arrayLower :: ExpressionOf Postgresql r a (Array elem) => a -> Int -> Expr Postgresql r Int
- arrayUpper :: ExpressionOf Postgresql r a (Array elem) => a -> Int -> Expr Postgresql r Int
- arrayLength :: ExpressionOf Postgresql r a (Array elem) => a -> Int -> Expr Postgresql r Int
- arrayToString :: ExpressionOf Postgresql r a (Array elem) => a -> String -> Expr Postgresql r String
- stringToArray :: ExpressionOf Postgresql r a String => a -> String -> Expr Postgresql r (Array String)
- any :: (ExpressionOf Postgresql r a elem, ExpressionOf Postgresql r b (Array elem)) => a -> b -> Cond Postgresql r
- all :: (ExpressionOf Postgresql r a elem, ExpressionOf Postgresql r b (Array elem)) => a -> b -> Cond Postgresql r
- (@>) :: (ExpressionOf Postgresql r a (Array elem), ExpressionOf Postgresql r b (Array elem)) => a -> b -> Cond Postgresql r
- (<@) :: (ExpressionOf Postgresql r a (Array elem), ExpressionOf Postgresql r b (Array elem)) => a -> b -> Cond Postgresql r
- overlaps :: (ExpressionOf Postgresql r a (Array elem), ExpressionOf Postgresql r b (Array elem)) => a -> b -> Cond Postgresql r
Documentation
Represents PostgreSQL arrays
Array [a] |
Instances
Eq a => Eq (Array a) Source # | |
Show a => Show (Array a) Source # | |
ToJSON a => ToJSON (Array a) Source # | |
Defined in Database.Groundhog.Postgresql.Array | |
FromJSON a => FromJSON (Array a) Source # | |
(ArrayElem a, PrimitivePersistField a) => PersistField (Array a) Source # | |
Defined in Database.Groundhog.Postgresql.Array persistName :: Array a -> String # toPersistValues :: PersistBackend m => Array a -> m ([PersistValue] -> [PersistValue]) # fromPersistValues :: PersistBackend m => [PersistValue] -> m (Array a, [PersistValue]) # dbType :: DbDescriptor db => proxy db -> Array a -> DbType # | |
(ArrayElem a, PrimitivePersistField a) => PrimitivePersistField (Array a) Source # | |
Defined in Database.Groundhog.Postgresql.Array toPrimitivePersistValue :: Array a -> PersistValue # fromPrimitivePersistValue :: PersistValue -> Array a # |
(!) :: (ExpressionOf Postgresql r a (Array elem), ExpressionOf Postgresql r b Int) => a -> b -> Expr Postgresql r elem Source #
(!:) :: (ExpressionOf Postgresql r a (Array elem), ExpressionOf Postgresql r i1 Int, ExpressionOf Postgresql r i2 Int) => a -> (i1, i2) -> Expr Postgresql r (Array elem) Source #
append :: (ExpressionOf Postgresql r a (Array elem), ExpressionOf Postgresql r b elem) => a -> b -> Expr Postgresql r (Array elem) Source #
prepend :: (ExpressionOf Postgresql r a elem, ExpressionOf Postgresql r b (Array elem)) => a -> b -> Expr Postgresql r (Array elem) Source #
arrayCat :: (ExpressionOf Postgresql r a (Array elem), ExpressionOf Postgresql r b (Array elem)) => a -> b -> Expr Postgresql r (Array elem) Source #
arrayDims :: ExpressionOf Postgresql r a (Array elem) => a -> Expr Postgresql r String Source #
arrayNDims :: ExpressionOf Postgresql r a (Array elem) => a -> Expr Postgresql r Int Source #
arrayLower :: ExpressionOf Postgresql r a (Array elem) => a -> Int -> Expr Postgresql r Int Source #
arrayUpper :: ExpressionOf Postgresql r a (Array elem) => a -> Int -> Expr Postgresql r Int Source #
arrayLength :: ExpressionOf Postgresql r a (Array elem) => a -> Int -> Expr Postgresql r Int Source #
arrayToString :: ExpressionOf Postgresql r a (Array elem) => a -> String -> Expr Postgresql r String Source #
Concatenates array elements using supplied delimiter. array_to_string(ARRAY[1, 2, 3], ~^~
) = 1~^~2~^~3
stringToArray :: ExpressionOf Postgresql r a String => a -> String -> Expr Postgresql r (Array String) Source #
Splits string into array elements using supplied delimiter. string_to_array('xx~^~yy~^~zz', ~^~
) = {xx,yy,zz}
any :: (ExpressionOf Postgresql r a elem, ExpressionOf Postgresql r b (Array elem)) => a -> b -> Cond Postgresql r Source #
all :: (ExpressionOf Postgresql r a elem, ExpressionOf Postgresql r b (Array elem)) => a -> b -> Cond Postgresql r Source #
(@>) :: (ExpressionOf Postgresql r a (Array elem), ExpressionOf Postgresql r b (Array elem)) => a -> b -> Cond Postgresql r Source #
Contains. ARRAY[1,4,3] @> ARRAY[3,1] = t
(<@) :: (ExpressionOf Postgresql r a (Array elem), ExpressionOf Postgresql r b (Array elem)) => a -> b -> Cond Postgresql r Source #
Is contained by. ARRAY[2,7] <@ ARRAY[1,7,4,2,6] = t
overlaps :: (ExpressionOf Postgresql r a (Array elem), ExpressionOf Postgresql r b (Array elem)) => a -> b -> Cond Postgresql r Source #
Overlap (have elements in common). ARRAY[1,4,3] && ARRAY[2,1] = t