无法加入并在Sequel中选择-PG :: SyntaxError [英] Can't join and select in Sequel -- PG::SyntaxError

问题描述

我正在尝试重命名连接中的列：

I'm trying to rename a column at join:

    # ...............

    result = DB[:my_items1].join(:my_items2, id: :my_item2_id).
          select([Sequel[:my_items2][:name].as(:my_items_name), 
                  Sequel[:my_items2][:amount].as(:my_item2_amount)
          ])

    # ...............

异常：

Sequel::DatabaseError - PG::SyntaxError: ERROR:  syntax error at or near "AS"
LINE 1: SELECT ("my_items2"."name" AS "my_item2_name", "...
                                         ^
:

推荐答案

数据集#select接受多个参数，而不是单个数组：

Dataset#select takes multiple arguments, not a single array:

result = DB[:my_items1].join(:my_items2, id: :my_item2_id).
      select(Sequel[:my_items2][:name].as(:my_items_name), 
              Sequel[:my_items2][:amount].as(:my_item2_amount)
      )

这篇关于无法加入并在Sequel中选择-PG :: SyntaxError的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！