Database.PostgreSQL.PQTypes.SQL

Documentation

data SQL

Primary SQL type that supports efficient concatenation and variable number of parameters.

Instances

Show SQL

IsString SQL

Construct SQL from String. The underlying ByteString will be encoded as UTF-8, so if you are working with a different encoding, you should not rely on this instance.

Monoid SQL

IsSQL SQL

mkSQL :: ByteString -> SQL

Convert ByteString to SQL.

sqlParam :: (Show t, ToSQL t) => t -> SQL

Embed parameter value inside SQL.

(<?>) :: (Show t, ToSQL t) => SQL -> t -> SQL infixr 7

Embed parameter value inside existing SQL. Example:

f :: Int32 -> String -> SQL
f idx name = "SELECT foo FROM bar WHERE id =" <?> idx <+> "AND name =" <?> name

isSqlEmpty :: SQL -> Bool

Test whether an SQL is empty.