Hoogle Search
Within LTS Haskell 24.22 (ghc-9.10.3)
Note that Stackage only displays results for the latest LTS and Nightly snapshot. Learn more.
(
.|. ) :: Bits a => a -> a -> aprotolude Protolude Bitwise "or"
(
||. ) :: SqlExpr (Value Bool) -> SqlExpr (Value Bool) -> SqlExpr (Value Bool)esqueleto Database.Esqueleto This operator translates to the SQL operator AND. Example:
where_ $ user ^. UserName ==. val Matt ||. user ^. UserName ==. val John
(
||. ) :: SqlExpr (Value Bool) -> SqlExpr (Value Bool) -> SqlExpr (Value Bool)esqueleto Database.Esqueleto.Experimental This operator translates to the SQL operator AND. Example:
where_ $ user ^. UserName ==. val Matt ||. user ^. UserName ==. val John
(
||. ) :: SqlExpr (Value Bool) -> SqlExpr (Value Bool) -> SqlExpr (Value Bool)esqueleto Database.Esqueleto.Internal.Internal This operator translates to the SQL operator AND. Example:
where_ $ user ^. UserName ==. val Matt ||. user ^. UserName ==. val John
(
||. ) :: SqlExpr (Value Bool) -> SqlExpr (Value Bool) -> SqlExpr (Value Bool)esqueleto Database.Esqueleto.Legacy This operator translates to the SQL operator AND. Example:
where_ $ user ^. UserName ==. val Matt ||. user ^. UserName ==. val John
(
?|. ) :: JSONBExpr a -> [Text] -> SqlExpr (Value Bool)esqueleto Database.Esqueleto.PostgreSQL.JSON Requires PostgreSQL version >= 9.4 This operator checks if ANY of the given texts is a top-level member of the JSON value on the left. This means any top-level field in an object, any top-level string in an array or just a string value. Examples of the usage of this operator can be found in the Database.Persist.Postgresql.JSON module. (here: https://hackage.haskell.org/package/persistent-postgresql-2.10.0/docs/Database-Persist-Postgresql-JSON.html)
PostgreSQL Documentation
| Type | Description | Example ----+--------+--------------------------------------------------------+--------------------------------------------------- ?| | text[] | Do any of these array strings exist as top-level keys? | '{"a":1, "b":2, "c":3}'::jsonb ?| array[b, c](
||. ) :: JSONBExpr a -> JSONBExpr b -> JSONBExpr cesqueleto Database.Esqueleto.PostgreSQL.JSON Requires PostgreSQL version >= 9.5 This operator concatenates two JSON values. The behaviour is self-evident when used on two arrays, but the behaviour on different combinations of JSON values might behave unexpectedly. CAUTION: THIS FUNCTION THROWS AN EXCEPTION WHEN CONCATENATING A JSON OBJECT WITH A JSON SCALAR VALUE!
Arrays
This operator is a standard concatenation function when used on arrays:[1,2] || [2,3] == [1,2,2,3] [] || [1,2,3] == [1,2,3] [1,2,3] || [] == [1,2,3]
Objects
When concatenating JSON objects with other JSON objects, the fields from the JSON object on the right are added to the JSON object on the left. When concatenating a JSON object with a JSON array, the object will be inserted into the array; either on the left or right, depending on the position relative to the operator. When concatening an object with a scalar value, an exception is thrown.{"a": 3.14} || {"b": true} == {"a": 3.14, "b": true} {"a": "b"} || {"a": null} == {"a": null} {"a": {"b": true, "c": false}} || {"a": {"b": false}} == {"a": {"b": false}} {"a": 3.14} || [1,null] == [{"a": 3.14},1,null] [1,null] || {"a": 3.14} == [1,null,{"a": 3.14}] 1 || {"a": 3.14} == ERROR: invalid concatenation of jsonb objects {"a": 3.14} || false == ERROR: invalid concatenation of jsonb objectsScalar values
Scalar values can be thought of as being singleton arrays when used with this operator. This rule does not apply when concatenating with JSON objects.1 || null == [1,null] true || "a" == [true,"a"] [1,2] || false == [1,2,false] null || [1,"a"] == [null,1,"a"] {"a":3.14} || true == ERROR: invalid concatenation of jsonb objects 3.14 || {"a":3.14} == ERROR: invalid concatenation of jsonb objects {"a":3.14} || [true] == [{"a":3.14},true] [false] || {"a":3.14} == [false,{"a":3.14}]PostgreSQL Documentation
| Type | Description | Example ----+-------+-----------------------------------------------------+-------------------------------------------- || | jsonb | Concatenate two jsonb values into a new jsonb value | '["a", "b"]'::jsonb || '["c", "d"]'::jsonb
Note: The || operator concatenates the elements at the top level of each of its operands. It does not operate recursively. For example, if both operands are objects with a common key field name, the value of the field in the result will just be the value from the right hand operand.(
.|. ) :: JStgExpr -> JStgExpr -> JStgExprghc-lib-parser GHC.JS.Make JS infix bit operators
(
.||. ) :: JStgExpr -> JStgExpr -> JStgExprghc-lib-parser GHC.JS.Make JS infix bit operators
(
.|. ) :: Bits a => a -> a -> aghc-lib-parser GHC.Prelude.Basic Bitwise "or"