class Sequel::Postgres::JSONBSubscriptOp

Represents JSONB subscripts. This is abstracted because the subscript support depends on the database version.

Constants

SUBSCRIPT

Attributes

expression [R]

The expression being subscripted

sub [R]

The subscript to use

Public Class Methods

new (expression, sub)

Source

    # File lib/sequel/extensions/pg_json_ops.rb
887 def initialize(expression, sub)
888   @expression = expression
889   @sub = sub
890   freeze
891 end

Set the expression and subscript to the given arguments

Public Instance Methods

sequel_ast_transform (transformer)

Source

    # File lib/sequel/extensions/pg_json_ops.rb
901 def sequel_ast_transform(transformer)
902   self.class.new(transformer.call(@expression), transformer.call(@sub))
903 end

Support transforming of jsonb subscripts

to_s_append (ds, sql)

Source

    # File lib/sequel/extensions/pg_json_ops.rb
894 def to_s_append(ds, sql)
895   server_version = ds.db.server_version
896   frag = server_version && server_version >= 140000 ? SUBSCRIPT : JSONOp::GET
897   ds.literal_append(sql, Sequel::SQL::PlaceholderLiteralString.new(frag, [@expression, @sub]))
898 end

Use subscripts instead of -> operator on PostgreSQL 14+