class Focus::JsonbExpression

Direct Known Subclasses

Defined in:

focus/expressions/jsonb_expression.cr

Constructors

Instance Method Summary

Instance methods inherited from class Focus::Expression

accept(visitor : SqlVisitor) : Nil accept, aliased(alias_str : String) : Focus::AliasedExpression aliased, in_list(expressions : Array(Focus::Expression)) : Focus::BoolExpression
in_list(statement : Focus::SelectStatement) : Focus::BoolExpression
in_list(*expressions : Focus::Expression) : Focus::BoolExpression
in_list
, is_not_null : Focus::BoolExpression is_not_null, is_null : Focus::BoolExpression is_null, not_in_list(expressions : Array(Focus::Expression)) : Focus::BoolExpression
not_in_list(statement : Focus::SelectStatement) : Focus::BoolExpression
not_in_list(*expressions : Focus::Expression) : Focus::BoolExpression
not_in_list

Constructor Detail

def self.new(inner : Focus::Expression | Nil = nil) #

[View source]

Instance Method Detail

PostgreSQL JSONB concatenation operator ||


[View source]
def contained_by(rhs : Focus::JsonbExpression) : Focus::BoolExpression #

PostgreSQL JSONB containment operator <@


[View source]

PostgreSQL JSONB containment operator @>


[View source]
def delete(index : Focus::IntExpression(Int32)) : Focus::JsonbExpression #

PostgreSQL JSONB delete index operator -


[View source]

PostgreSQL JSONB delete key operator -


[View source]
def delete_path(path : Focus::Expression) : Focus::JsonbExpression #

PostgreSQL JSONB delete path operator #-


[View source]

[View source]
def get(index : Focus::IntExpression(Int32)) : Focus::JsonbExpression #

PostgreSQL JSONB path operator -> with integer index


[View source]

PostgreSQL JSONB path operator ->


[View source]
def get_path(path : Focus::Expression) : Focus::JsonbExpression #

PostgreSQL JSONB path operator #>


[View source]
def get_path_text(path : Focus::Expression) : Focus::StringExpression #

PostgreSQL JSONB path operator #>> returns text


[View source]
def get_text(index : Focus::IntExpression(Int32)) : Focus::StringExpression #

PostgreSQL JSONB path operator ->> with integer index returns text


[View source]

PostgreSQL JSONB path operator ->> returns text


[View source]
def has_all_keys(keys : Focus::Expression) : Focus::BoolExpression #

PostgreSQL JSONB all keys existence operator ?&


[View source]
def has_any_key(keys : Focus::Expression) : Focus::BoolExpression #

PostgreSQL JSONB any key existence operator ?|


[View source]

PostgreSQL JSONB key existence operator ?


[View source]
def inner : Focus::Expression | Nil #

[View source]
def is_distinct_from(rhs : Focus::JsonbExpression) : Focus::BoolExpression #

[View source]
def is_not_distinct_from(rhs : Focus::JsonbExpression) : Focus::BoolExpression #

[View source]

[View source]