[Rant] Oracle and the Boolean Type

A long time ago I used Oracle (I think it was something like 7 or 8 version)... there was no boolean type at that time, ok.

Then I mainly used SqlServer, MySql and PostgreSql.
They all have some sort of boolean type:

• SqlServer use 'bit'
• MySql has 'bit', 'bool' or 'boolean' which are all tinyint(1) under the cover but that's none of our business
• PostgreSql has a 'boolean' type (with valid values true/false, t/f, 0/1)

How is it possible that a database costing $40 000 per cpu, DOESN'T HAVE A BOOLEAN TYPE!! (and they have boolean in plsql!)

Apparently you need to use an number(1) to store those kind of values... How lame!

And don't get me started on the auto-increment columns ;)