Database.Groundhog.Postgresql.Array

See detailed documentation for PostgreSQL arrays at http:www.postgresql.orgdocs9.2staticarrays.html and http:www.postgresql.orgdocs9.2staticfunctions-array.html

Documentation

newtype Array a

Represents PostgreSQL arrays

Constructors

Array [a]

Instances

Eq a => Eq (Array a)

Show a => Show (Array a)

(ArrayElem a, PersistField a) => PersistField (Array a)

(ArrayElem a, PersistField a) => PrimitivePersistField (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