groundhog-postgresql-0.8.0.3: PostgreSQL backend for the groundhog library.

Safe Haskell	None
Language	Haskell98

Database.Groundhog.Postgresql.Array

Description

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

Documentation

newtype Array a #

Represents PostgreSQL arrays

Constructors

Instances

Eq a => Eq (Array a) #
Methods (==) :: Array a -> Array a -> Bool # (/=) :: Array a -> Array a -> Bool #
Show a => Show (Array a) #
Methods showsPrec :: Int -> Array a -> ShowS # show :: Array a -> String # showList :: [Array a] -> ShowS #
ToJSON a => ToJSON (Array a) #
Methods toJSON :: Array a -> Value # toEncoding :: Array a -> Encoding # toJSONList :: [Array a] -> Value # toEncodingList :: [Array a] -> Encoding #
FromJSON a => FromJSON (Array a) #
Methods parseJSON :: Value -> Parser (Array a) # parseJSONList :: Value -> Parser [Array a] #
(ArrayElem a, PrimitivePersistField a) => PersistField (Array a) #
Methods 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) #
Methods 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 #

(!:) :: (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 #

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) #

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 #

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 #

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 #

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 #

Overlap (have elements in common). ARRAY[1,4,3] && ARRAY[2,1] = t