Safe Haskell	None
Language	Haskell2010

Database.PostgreSQL.PQTypes.SQL

Synopsis

Documentation

data SQL #

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

Instances

Show SQL #
Methods showsPrec :: Int -> SQL -> ShowS # show :: SQL -> String # showList :: [SQL] -> ShowS #
IsString SQL #	Construct `SQL` from `String`.
Methods fromString :: String -> SQL #
Monoid SQL #
Methods mempty :: SQL # mappend :: SQL -> SQL -> SQL # mconcat :: [SQL] -> SQL #
IsSQL SQL #
Methods withSQL :: SQL -> ParamAllocator -> (Ptr PGparam -> CString -> IO r) -> IO r #

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

Test whether an SQL is empty.