I like Postgres's boolean type - why do you suppose neither Mysql nor Oracle has bothered to implement it? Booleans are in the SQL-99 spec. CSN __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match