Hello, I'm working on a Postgres DB and was stumbling over the following statement I wanted to create with Sequel. In fact I just want combine the values of two columns into a collection, but this would be my SQL statement.
SELECT col1, col2, (ARRAY[col3] || col4) AS col34 , col5 , ... FROM sample_table Is it somehow possible to create such a statement in Sequel? Or does anybody has an approach how to solve this problem? Atm I collect all the desired column in an array an splat them when calling select() like DB[:sample_table].select(*my_columns) Inside the array my sample col3 would be the desired Sequel::Postgres:.ArrayOp object, but unfortunately select removes it so it will be plain 'col3'. I'm using Sequel 4.9.0. and Postgres 9.3. Thank you all so much in advance for your efforts. Have a nice weekend, Ida -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.
