Rel8.Expr.Text

String concatenation

(++.) :: Expr Text -> Expr Text -> Expr Text infixr 6

The PostgreSQL string concatenation operator.

Regular expression operators

(~.) :: Expr Text -> Expr Text -> Expr Bool infix 2

Matches regular expression, case sensitive

Corresponds to the ~. operator.

(~*) :: Expr Text -> Expr Text -> Expr Bool infix 2

Matches regular expression, case insensitive

Corresponds to the ~* operator.

(!~) :: Expr Text -> Expr Text -> Expr Bool infix 2

Does not match regular expression, case sensitive

Corresponds to the !~ operator.

(!~*) :: Expr Text -> Expr Text -> Expr Bool infix 2

Does not match regular expression, case insensitive

Corresponds to the !~* operator.

Standard SQL functions

bitLength :: Expr Text -> Expr Int32

Corresponds to the bit_length function.

charLength :: Expr Text -> Expr Int32

Corresponds to the char_length function.

lower :: Expr Text -> Expr Text

Corresponds to the lower function.

octetLength :: Expr Text -> Expr Int32

Corresponds to the octet_length function.

upper :: Expr Text -> Expr Text

Corresponds to the upper function.

PostgreSQL functions

ascii :: Expr Text -> Expr Int32

Corresponds to the ascii function.

btrim :: Expr Text -> Maybe (Expr Text) -> Expr Text

Corresponds to the btrim function.

chr :: Expr Int32 -> Expr Text

Corresponds to the chr function.

convert :: Expr ByteString -> Expr Text -> Expr Text -> Expr ByteString

Corresponds to the convert function.

convertFrom :: Expr ByteString -> Expr Text -> Expr Text

Corresponds to the convert_from function.

convertTo :: Expr Text -> Expr Text -> Expr ByteString

Corresponds to the convert_to function.

decode :: Expr Text -> Expr Text -> Expr ByteString

Corresponds to the decode function.

encode :: Expr ByteString -> Expr Text -> Expr Text

Corresponds to the encode function.

initcap :: Expr Text -> Expr Text

Corresponds to the initcap function.

left :: Expr Text -> Expr Int32 -> Expr Text

Corresponds to the left function.

length :: Expr Text -> Expr Int32

Corresponds to the length function.

lengthEncoding :: Expr ByteString -> Expr Text -> Expr Int32

Corresponds to the length function.

lpad :: Expr Text -> Expr Int32 -> Maybe (Expr Text) -> Expr Text

Corresponds to the lpad function.

ltrim :: Expr Text -> Maybe (Expr Text) -> Expr Text

Corresponds to the ltrim function.

md5 :: Expr Text -> Expr Text

Corresponds to the md5 function.

pgClientEncoding :: Expr Text

Corresponds to the pg_client_encoding() expression.

quoteIdent :: Expr Text -> Expr Text

Corresponds to the quote_ident function.

quoteLiteral :: Expr Text -> Expr Text

Corresponds to the quote_literal function.

quoteNullable :: Expr Text -> Expr Text

Corresponds to the quote_nullable function.

regexpReplace :: Expr Text -> Expr Text -> Expr Text -> Maybe (Expr Text) -> Expr Text

Corresponds to the regexp_replace function.

regexpSplitToArray :: Expr Text -> Expr Text -> Maybe (Expr Text) -> Expr [Text]

Corresponds to the regexp_split_to_array function.

repeat :: Expr Text -> Expr Int32 -> Expr Text

Corresponds to the repeat function.

replace :: Expr Text -> Expr Text -> Expr Text -> Expr Text

Corresponds to the replace function.

reverse :: Expr Text -> Expr Text

Corresponds to the reverse function.

right :: Expr Text -> Expr Int32 -> Expr Text

Corresponds to the right function.

rpad :: Expr Text -> Expr Int32 -> Maybe (Expr Text) -> Expr Text

Corresponds to the rpad function.

rtrim :: Expr Text -> Maybe (Expr Text) -> Expr Text

Corresponds to the rtrim function.

splitPart :: Expr Text -> Expr Text -> Expr Int32 -> Expr Text

Corresponds to the split_part function.

strpos :: Expr Text -> Expr Text -> Expr Int32

Corresponds to the strpos function.

substr :: Expr Text -> Expr Int32 -> Maybe (Expr Int32) -> Expr Text

Corresponds to the substr function.

translate :: Expr Text -> Expr Text -> Expr Text -> Expr Text

Corresponds to the translate function.