Hi Jeremy,
I have an `agent_role' enum type in my Postgres database, and a table with
a `roles' column, type `agent_role[]'. I'd like to filter records in this
table where the `roles' column contains a certain `agent_role'.
This works:
.where('sales_representative'=>Sequel[:roles].pg_array.any) #
=> ('sales_representative' = ANY("roles"))
But I can't seem to make this work (the terms get reversed and Postgres
doesn't like it):
.where { 'sales_representative' =~ roles.pg_array.any } #
=> (ANY("roles") = 'sales_representative'))
Any tips?
I also wanted to ask if are any other/better ways to structure this
expression (aside from loading core extensions/refinements for some
additional sugar).
Thank you!
Mike
--
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 sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/sequel-talk/46637b01-7b37-424c-bf0a-2993111a6c29n%40googlegroups.com.
