How to order with an SQL array slice in Sequel?

Question

What is the proper syntax in Sequel to order by a slice of an SQL array value?

Here's what I want to do in SQL:

SELECT
  a,                -- column with SQL array values
  depth,
  name
FROM
  nodes
ORDER BY
  a[0:depth], name  -- sort by 'a' ignoring last element, then by 'name'

In Sequel, I could do:

DB[:nodes].select(:a, :depth, :name).order(:a, :name)

but this sorts by all of :a, not the [0:depth] slice as desired. What's the proper syntax?

jwfearn · Accepted Answer · 2012-03-01 22:09:17Z

1

This works:

DB[:nodes].select(:a, :depth, :name).order('a[0:depth]'.lit, :name)

Any better suggestions?

answered Mar 1, 2012 at 22:09

jwfearn

29.8k28 gold badges102 silver badges125 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jeremy Evans Over a year ago

That looks like the best way. Sequel's DSL has no support for the [0:depth] syntax. You could do :a.sql_subscript('0:depth'.lit), but that doesn't buy you much.

Collectives™ on Stack Overflow

How to order with an SQL array slice in Sequel?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related