NoSQL always seemed like a misnomer, should be SomeSQL, postgresql can do the same kinda ops and usually faster than your average NoSQL db:
http://www.enterprisedb.com/nosql-for-enterprise
Certainly the majority of proponents I speak to want to use noSQL databases without any real reason, and where a relational database would be a better fit.