class Sequel::SQL::Subscript

Represents an SQL array access, with multiple possible arguments.

The SQL array column

The SQL array column

The array of subscripts to use (should be an array of numbers)

Source

     # File lib/sequel/sql.rb
1821 def initialize(expression, sub)
1822   @expression = expression
1823   @sub = sub
1824   freeze
1825 end

Set the array column and subscripts to the given arguments

Source

     # File lib/sequel/sql.rb
1841 def [](sub)
1842   Subscript.new(self, Array(sub))
1843 end

Create a new Subscript by accessing a subarray of a multidimensional array.

Sequel[:a].sql_subscript(2) # a[2]
Sequel[:a].sql_subscript(2)[1] # a[2][1]

Source

     # File lib/sequel/sql.rb
1832 def |(sub)
1833   Subscript.new(@expression, @sub + Array(sub))
1834 end

Create a new Subscript appending the given subscript(s) to the current array of subscripts.

Sequel[:a].sql_subscript(2) # a[2]
Sequel[:a].sql_subscript(2) | 1 # a[2, 1]