On Mar 2, 1:00 pm, Clive Crous <[email protected]> wrote: > My only problem with String#lit is that it's not compatible across database > types. Admittedly none of the proposed solutions are, yet it seems very > strange to me that where database independence is given precedence > everywhere else within the source, here it's not :/ > I will, obviously, use String#lit for now but I do think an eventual proper > solution to this should be found.
Do prefix indexes use different SQL syntax on different databases? String#lit is only not compatible if you are using SQL syntax on one database that is different on another database. If all databases use the same syntax, then String#lit is compatible. Sequel does attempt to abstract SQL syntax differences. If there are differences in SQL syntax for prefix indexes, it would make sense for Sequel to provide a way to create them in a database independent manner. However, until I see evidence of that, I recommend String#lit be used. Jeremy --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en -~----------~----~----~----~------~----~------~--~---
