opaleye-0.5.0.0: An SQL-generating DSL targeting PostgreSQL

Safe HaskellNone
LanguageHaskell98

Opaleye.Binary

Synopsis

Documentation

unionAll :: Default Binaryspec columns columns => Query columns -> Query columns -> Query columns Source

Example type specialization:

unionAll :: Query (Column a, Column b)
         -> Query (Column a, Column b)
         -> Query (Column a, Column b)

Assuming the makeAdaptorAndInstance splice has been run for the product type Foo:

unionAll :: Query (Foo (Column a) (Column b) (Column c))
         -> Query (Foo (Column a) (Column b) (Column c))
         -> Query (Foo (Column a) (Column b) (Column c))

By design there is no union function of type QueryArr a b -> QueryArr a b -> QueryArr a b. Such a function would allow violation of SQL's scoping rules and lead to invalid queries.

unionAllExplicit :: Binaryspec columns columns' -> Query columns -> Query columns -> Query columns' Source

union :: Default Binaryspec columns columns => Query columns -> Query columns -> Query columns Source

The same as unionAll, except that it additionally removes any duplicate rows.

unionExplicit :: Binaryspec columns columns' -> Query columns -> Query columns -> Query columns' Source

intersectAll :: Default Binaryspec columns columns => Query columns -> Query columns -> Query columns Source

intersectAllExplicit :: Binaryspec columns columns' -> Query columns -> Query columns -> Query columns' Source

intersect :: Default Binaryspec columns columns => Query columns -> Query columns -> Query columns Source

The same as intersectAll, except that it additionally removes any duplicate rows.

intersectExplicit :: Binaryspec columns columns' -> Query columns -> Query columns -> Query columns' Source

exceptAll :: Default Binaryspec columns columns => Query columns -> Query columns -> Query columns Source

exceptAllExplicit :: Binaryspec columns columns' -> Query columns -> Query columns -> Query columns' Source

except :: Default Binaryspec columns columns => Query columns -> Query columns -> Query columns Source

The same as exceptAll, except that it additionally removes any duplicate rows.

exceptExplicit :: Binaryspec columns columns' -> Query columns -> Query columns -> Query columns' Source