# ANN: Sequel 0.1.2 Released

**URL:** <https://www.ruby-forum.com/t/ann-sequel-0-1-2-released/104558>\
**Category:** Ruby\
**Created:** [May 19, 2007, 3:08pm UTC](https://www.ruby-forum.com/t/ann-sequel-0-1-2-released/104558 "2007-05-19T15:08:41Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![ciconia](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/71c47a/32.png) [@ciconia](https://www.ruby-forum.com/u/ciconia)\
**Post date:** [May 19, 2007, 3:08pm UTC](https://www.ruby-forum.com/t/ann-sequel-0-1-2-released/104558/1 "2007-05-19T15:08:41Z")

</div>

Sequel version 0.1.2 has just been released. This release contains  
vaious bug fixes and enhancements. Here are the important changes:

- Support for SQL set operations (UNION, INTERSECT and EXCEPT):

DB[:a].union(DB[:b]).sql #=\>  
“SELECT \* FROM a UNION SELECT \* FROM b”

The #union, #intersect and #except methods take an optional second  
parameter to specify ALL for the clause:

DB[:a].intersect(DB[:b], true).sql #=\>  
“SELECT \* FROM a INTERSECT ALL SELECT \* FROM b”

- SequelConnectionError has been removed, as it caused a some  
difficulties dealing with non DB-related errors that were raised  
inside transactions. However, Exception errors are automatically  
converted into RuntimeError. Future releases might convert adapter-  
specific errors into standard Sequel errors.

- Added DSL for defining subsets in Model classes:

class A \< Sequel::Model(:a)  
subset(:high\_priced) {price \> 100}  
subset :china, :category =\> ‘china’  
end

A.high\_priced.sql #=\> “SELECT \* FROM a WHERE (price \> 100)”  
A.china.sql #=\> “SELECT \* FROM a WHERE (category = ‘china’)”

- Cleaned up PostgreSQL adapter code.

- Updated spec to conform with RSpec 1.0.

======================

Join the Sequel-talk group:  
[http://groups.google.com/group/sequel-talk](http://groups.google.com/group/sequel-talk)

Install the gem:  
sudo gem install sequel

Or check out the source and install locally:  
svn co [http://ruby-sequel.googlecode.com/svn/trunk](http://ruby-sequel.googlecode.com/svn/trunk) sequel  
cd sequel  
rake install