squeal-postgresql-0.9.0.0: Squeal PostgreSQL Library
Copyright(c) Eitan Chatav 2019
Maintainereitan@morphism.tech
Stabilityexperimental
Safe HaskellNone
LanguageHaskell2010

Squeal.PostgreSQL.Query.Values

Contents

Description

values statements

Synopsis

Values

values Source #

Arguments

:: SListI cols 
=> NP (Aliased (Expression 'Ungrouped lat with db params '[])) cols 
-> [NP (Aliased (Expression 'Ungrouped lat with db params '[])) cols]

When more than one row is specified, all the rows must must have the same number of elements

-> Query lat with db params cols 

values computes a row value or set of row values specified by value expressions. It is most commonly used to generate a “constant table” within a larger command, but it can be used on its own.

>>> type Row = '["a" ::: 'NotNull 'PGint4, "b" ::: 'NotNull 'PGtext]
>>> let query = values (1 `as` #a :* "one" `as` #b) [] :: Query lat with db '[] Row
>>> printSQL query
SELECT * FROM (VALUES ((1 :: int4), (E'one' :: text))) AS t ("a", "b")

values_ Source #

Arguments

:: SListI cols 
=> NP (Aliased (Expression 'Ungrouped lat with db params '[])) cols

one row of values

-> Query lat with db params cols 

values_ computes a row value or set of row values specified by value expressions.