postgresql-simple-0.7.0.1: Mid-Level PostgreSQL client library

Safe Haskell | None
Language | Haskell2010

Database.PostgreSQL.Simple.Vector

Description

`query` variants returning `Vector`.

Synopsis

- query :: (ToRow q, FromRow r) => Connection -> Query -> q -> IO (Vector r)
- query_ :: FromRow r => Connection -> Query -> IO (Vector r)
- queryWith :: ToRow q => RowParser r -> Connection -> Query -> q -> IO (Vector r)
- queryWith_ :: RowParser r -> Connection -> Query -> IO (Vector r)
- returning :: (ToRow q, FromRow r) => Connection -> Query -> [q] -> IO (Vector r)
- returningWith :: ToRow q => RowParser r -> Connection -> Query -> [q] -> IO (Vector r)

# Documentation

query :: (ToRow q, FromRow r) => Connection -> Query -> q -> IO (Vector r) Source #

Perform a `SELECT` or other SQL query that is expected to return results. All results are retrieved and converted before this function returns.

query_ :: FromRow r => Connection -> Query -> IO (Vector r) Source #

A version of `query` that does not perform query substitution.

queryWith :: ToRow q => RowParser r -> Connection -> Query -> q -> IO (Vector r) Source #

A version of `query` taking parser as argument

queryWith_ :: RowParser r -> Connection -> Query -> IO (Vector r) Source #

A version of `query_` taking parser as argument

returning :: (ToRow q, FromRow r) => Connection -> Query -> [q] -> IO (Vector r) Source #

Execute `INSERT ... RETURNING`, `UPDATE ... RETURNING`, or other SQL query that accepts multi-row input and is expected to return results.

returningWith :: ToRow q => RowParser r -> Connection -> Query -> [q] -> IO (Vector r) Source #

A version of `returning` taking parser as argument