On Thursday, December 20, 2012 12:20:39 PM UTC-7, Jeremy Evans wrote: > On Thursday, December 20, 2012 9:34:31 AM UTC-8, James wrote: >> >> On occasion I use Sequel with a PSQL database (using ODBC), which doesn't >> support LIMIT. What's the simplest way to add "TOP 10" to a dataset >> without reverting to writing the full SQL query string? > > > You probably want to modify the datasets for the database so that they use > TOP instead of LIMIT. Then you can just add .limit(10) to the dataset. > This might work: > > DB.extend_datasets do > SELECT_CLAUSE_METHODS = Sequel::Dataset.clause_methods(:select, > %w'select limit distinct columns from join where group having compounds > order lock') > TOP = " TOP " > def select_clause_methods > SELECT_CLAUSE_METHODS > end > def select_limit_sql(sql) > if l = opts[:limit] > sql << TOP > literal_append(sql, l) > end > end > end >
Thanks Jeremy, that works perfectly! :) -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To view this discussion on the web visit https://groups.google.com/d/msg/sequel-talk/-/Braa9TOwUo0J. 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.
