opaleye-0.6.0.0: An SQL-generating DSL targeting PostgreSQL

Safe HaskellNone
LanguageHaskell2010

Opaleye.Values

Synopsis

Documentation

values :: (Default Valuesspec columns columns, Default Unpackspec columns columns) => [columns] -> Query columns Source #

values implements Postgres's VALUES construct and allows you to create a query that consists of the given rows.

Example type specialization:

values :: [(Column a, Column b)] -> Query (Column a, Column b)

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

queryTable :: [Foo (Column a) (Column b) (Column c)] -> Query (Foo (Column a) (Column b) (Column c))

valuesExplicit :: Unpackspec columns columns' -> Valuesspec columns columns' -> [columns] -> Query columns' Source #