On Monday, February 19, 2018 at 10:20:02 AM UTC-8, João Alexandre wrote: > > Just as a curiosity, all the methods you suggested worked, but I had to > enclose *score* with single quotes in the first one and also in 2nd and > 3rd methods, instead of using symbol. Otherwise it complains that the > column does not exist. Anyway, now I can see the index being used with > "Explain Analyse...", and also sorting it properly (considering numeric). >
Yep, sorry, that was a bug in my example. score should be a string and not an identifier in SQL, so it should be a string and not a symbol in ruby. 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 https://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.
