Thanks Vinod, that did it... i hadn't realized that boolean can be referenced that way in case statements... i searched the postgresql docs, but didn't find it because i was searching for the wrong things... i was looking as cast statements, and not the properties of boolean values. Ah, the joys of learning a the little things when dealing with a database I'm new to.