I tried concat them with join([]), but your op.concat() did the trick. You saved my day! Thank you so much Jeremy.
On Friday, May 9, 2014 8:52:59 AM UTC-7, [email protected] wrote: >> >> 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? >> > > You can use the pg_array and pg_array_ops extensions: > > DB.extension :pg_array > Sequel.extension :pg_array_ops > DB[:sample_table].select(:col1, :col2, > Sequel.pg_array([:col3]).op.concat(:col4).as(:col34), :col5) > > Thanks, > Jeremy > -- 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.
