Class Sequel::SQL::Subscript
In: lib/sequel/sql.rb
Parent: GenericExpression

Represents an SQL array access, with multiple possible arguments.

Methods

[]   new   |  

Attributes

f  [R]  The SQL array column
sub  [R]  The array of subscripts to use (should be an array of numbers)

Public Class methods

Set the array column and subscripts to the given arguments

[Source]

      # File lib/sequel/sql.rb, line 1643
1643:       def initialize(f, sub)
1644:         @f, @sub = f, sub
1645:       end

Public Instance methods

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

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

[Source]

      # File lib/sequel/sql.rb, line 1661
1661:       def [](sub)
1662:         Subscript.new(self, Array(sub))
1663:       end

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

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

[Source]

      # File lib/sequel/sql.rb, line 1652
1652:       def |(sub)
1653:         Subscript.new(@f, @sub + Array(sub))
1654:       end

[Validate]