Database.Groundhog.Postgresql.Array

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

Documentation

newtype Array a

Represents PostgreSQL arrays

Constructors

Array [a]

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