Database.Esqueleto.Experimental.From.SqlSetOperation

Documentation

newtype SqlSetOperation a

Data type used to implement the SqlSetOperation language this type is implemented in the same way as a From

Semantically a SqlSetOperation is always a From but not vice versa

Since: 3.5.0.0

Constructors

SqlSetOperation

Fields

• unSqlSetOperation :: NeedParens -> SqlQuery (a, IdentInfo -> (Builder, [PersistValue]))

Instances

ToAliasReference a => ToFrom (SqlSetOperation a) a

Defined in Database.Esqueleto.Experimental.From.SqlSetOperation

Methods

toFrom :: SqlSetOperation a -> From a

ToSqlSetOperation (SqlSetOperation a) a

Defined in Database.Esqueleto.Experimental.From.SqlSetOperation

Methods

toSqlSetOperation :: SqlSetOperation a -> SqlSetOperation a

class ToSqlSetOperation a r | a -> r where

Type class to support direct use of SqlQuery in a set operation tree

Since: 3.5.0.0

Methods

toSqlSetOperation :: a -> SqlSetOperation r

Instances

ToSqlSetOperation (SqlSetOperation a) a

Defined in Database.Esqueleto.Experimental.From.SqlSetOperation

Methods

toSqlSetOperation :: SqlSetOperation a -> SqlSetOperation a

(SqlSelect a r, ToAlias a, ToAliasReference a) => ToSqlSetOperation (SqlQuery a) a

Defined in Database.Esqueleto.Experimental.From.SqlSetOperation

Methods

toSqlSetOperation :: SqlQuery a -> SqlSetOperation a

mkSetOperation :: (ToSqlSetOperation a a', ToSqlSetOperation b a') => Builder -> a -> b -> SqlSetOperation a'

Helper function for defining set operations @since 3.5.0.0

class Union_ a where

Overloaded union_ function to support use in both SqlSetOperation and withRecursive

Since: 3.5.0.0

Methods

union_ :: a

UNION SQL set operation. Can be used as an infix function between SqlQuery values.

Instances

Union_ UnionKind

Defined in Database.Esqueleto.Experimental.From.CommonTableExpression

Methods

union_ :: UnionKind

(ToSqlSetOperation a c, ToSqlSetOperation b c, res ~ SqlSetOperation c) => Union_ (a -> b -> res)

Defined in Database.Esqueleto.Experimental.From.SqlSetOperation

Methods

union_ :: a -> b -> res

class UnionAll_ a where

Overloaded unionAll_ function to support use in both SqlSetOperation and withRecursive

Since: 3.5.0.0

Methods

unionAll_ :: a

UNION ALL SQL set operation. Can be used as an infix function between SqlQuery values.

Instances

UnionAll_ UnionKind

Defined in Database.Esqueleto.Experimental.From.CommonTableExpression

Methods

unionAll_ :: UnionKind

(ToSqlSetOperation a c, ToSqlSetOperation b c, res ~ SqlSetOperation c) => UnionAll_ (a -> b -> res)

Defined in Database.Esqueleto.Experimental.From.SqlSetOperation

Methods

unionAll_ :: a -> b -> res

except_ :: (ToSqlSetOperation a a', ToSqlSetOperation b a') => a -> b -> SqlSetOperation a'

EXCEPT SQL set operation. Can be used as an infix function between SqlQuery values.

intersect_ :: (ToSqlSetOperation a a', ToSqlSetOperation b a') => a -> b -> SqlSetOperation a'

INTERSECT SQL set operation. Can be used as an infix function between SqlQuery values.