Database.PostgreSQL.LQuery

This module provides types and functions for PostgreSQL's lquery https://www.postgresql.org/docs/current/ltree.html

You will want to use a specific implementation, e.g. postgresql-simple-ltree.

Documentation

newtype LQuery

Wrapper for Postgres' lquery (label tree query) type.

Constructors

LQuery

Fields

• unLQuery :: Text

Instances

Eq LQuery

Defined in Database.PostgreSQL.LQuery

Methods

(==) :: LQuery -> LQuery -> Bool

(/=) :: LQuery -> LQuery -> Bool

Ord LQuery

Defined in Database.PostgreSQL.LQuery

Methods

compare :: LQuery -> LQuery -> Ordering

(<) :: LQuery -> LQuery -> Bool

(<=) :: LQuery -> LQuery -> Bool

(>) :: LQuery -> LQuery -> Bool

(>=) :: LQuery -> LQuery -> Bool

max :: LQuery -> LQuery -> LQuery

min :: LQuery -> LQuery -> LQuery

Show LQuery

Defined in Database.PostgreSQL.LQuery

Methods

showsPrec :: Int -> LQuery -> ShowS

show :: LQuery -> String

showList :: [LQuery] -> ShowS

ToJSON LQuery

Defined in Database.PostgreSQL.LQuery

Methods

toJSON :: LQuery -> Value

toEncoding :: LQuery -> Encoding

toJSONList :: [LQuery] -> Value

toEncodingList :: [LQuery] -> Encoding

FromJSON LQuery

Defined in Database.PostgreSQL.LQuery

Methods

parseJSON :: Value -> Parser LQuery

parseJSONList :: Value -> Parser [LQuery]

contains :: Label -> LQuery

Build an lquery expression which matches any ltree which contains the given label.