Jumar.Query (Jumar v0.1.0)

View Source

Additional query macros and functions for Jumar and Cockroach DB.

Summary

Functions

Collates a field as case insensitive English. This is to work around Cockroach DB not having native support for case insensitive text.

Functions

citext(something)

(macro)

Collates a field as case insensitive English. This is to work around Cockroach DB not having native support for case insensitive text.

See this Cockroach DB issue #22463 for more information about the feature and workaround suggested.

Examples

import Ecto.Query
import Jumar.Query

from m in MySchema,
  where: citext(m.name) == "John Doe"