Re: boolean or int2

On Tue, 2 Aug 2005 10:31:17 -0700 (PDT), operationsengineer1 wrote
> i have a situation where widgets either pass or fail a
> test and i record the result.
> 
> i'm thinking of using boolean to track this - true for
> pass, false for fail.
> 
> i've used int2 in other situations b/c i couldn't be
> as sure that only two outcomes were possible.  i could
> use int2 here, also (ie, 0 for fail, 1 for pass).
> 
> does it make a practical difference which one i use?
> 
> as always, thanks for the help. it is much appreciated.

Personally I like to use a boolean to make the code a little more self
documenting.  With a column name like passed_test and a boolean your code ends
up looking like

WHERE passed_test

or

WHERE NOT passed_test

Kind Regards,
Keith