class Arel::Visitors::PostgreSQL

Experimental RBS support (using type sampling data from the type_fusion project).

# sig/arel/visitors/postgresql.rbs

class Arel::Visitors::PostgreSQL < Arel::Visitors::Arel::Visitors::ToSql
  def bind_block: () -> untyped
end

def bind_block; BIND_BLOCK; end

Experimental RBS support (using type sampling data from the type_fusion project).

def bind_block: () -> untyped

This signature was generated using 5 samples from 1 application.

def bind_block; BIND_BLOCK; end

def grouping_array_or_grouping_element(o, collector)

handle grouping aggregation semantics
Utilized by GroupingSet, Cube & RollUp visitors to
def grouping_array_or_grouping_element(o, collector)
  if o.expr.is_a? Array
    collector << "( "
    visit o.expr, collector
    collector << " )"
  else
    visit o.expr, collector
  end
end

def grouping_parentheses(o, collector)

Used by Lateral visitor to enclose select queries in parentheses
def grouping_parentheses(o, collector)
  if o.expr.is_a? Nodes::SelectStatement
    collector << "("
    visit o.expr, collector
    collector << ")"
  else
    visit o.expr, collector
  end
end

def visit_Arel_Nodes_Cube(o, collector)

def visit_Arel_Nodes_Cube(o, collector)
  collector << "CUBE"
  grouping_array_or_grouping_element o, collector
end

def visit_Arel_Nodes_DistinctOn(o, collector)

def visit_Arel_Nodes_DistinctOn(o, collector)
  collector << "DISTINCT ON ( "
  visit(o.expr, collector) << " )"
end

def visit_Arel_Nodes_DoesNotMatch(o, collector)

def visit_Arel_Nodes_DoesNotMatch(o, collector)
  op = o.case_sensitive ? " NOT LIKE " : " NOT ILIKE "
  collector = infix_value o, collector, op
  if o.escape
    collector << " ESCAPE "
    visit o.escape, collector
  else
    collector
  end
end

def visit_Arel_Nodes_GroupingElement(o, collector)

def visit_Arel_Nodes_GroupingElement(o, collector)
  collector << "( "
  visit(o.expr, collector) << " )"
end

def visit_Arel_Nodes_GroupingSet(o, collector)

def visit_Arel_Nodes_GroupingSet(o, collector)
  collector << "GROUPING SETS"
  grouping_array_or_grouping_element o, collector
end

def visit_Arel_Nodes_IsDistinctFrom(o, collector)

def visit_Arel_Nodes_IsDistinctFrom(o, collector)
  collector = visit o.left, collector
  collector << " IS DISTINCT FROM "
  visit o.right, collector
end

def visit_Arel_Nodes_IsNotDistinctFrom(o, collector)

def visit_Arel_Nodes_IsNotDistinctFrom(o, collector)
  collector = visit o.left, collector
  collector << " IS NOT DISTINCT FROM "
  visit o.right, collector
end

def visit_Arel_Nodes_Lateral(o, collector)

def visit_Arel_Nodes_Lateral(o, collector)
  collector << "LATERAL "
  grouping_parentheses o, collector
end

def visit_Arel_Nodes_Matches(o, collector)

def visit_Arel_Nodes_Matches(o, collector)
  op = o.case_sensitive ? " LIKE " : " ILIKE "
  collector = infix_value o, collector, op
  if o.escape
    collector << " ESCAPE "
    visit o.escape, collector
  else
    collector
  end
end

def visit_Arel_Nodes_NotRegexp(o, collector)

def visit_Arel_Nodes_NotRegexp(o, collector)
  op = o.case_sensitive ? " !~ " : " !~* "
  infix_value o, collector, op
end

def visit_Arel_Nodes_Regexp(o, collector)

def visit_Arel_Nodes_Regexp(o, collector)
  op = o.case_sensitive ? " ~ " : " ~* "
  infix_value o, collector, op
end

def visit_Arel_Nodes_RollUp(o, collector)

def visit_Arel_Nodes_RollUp(o, collector)
  collector << "ROLLUP"
  grouping_array_or_grouping_element o, collector
end