boolean or int2 - Mailing list pgsql-novice

From
Subject boolean or int2
Date
Msg-id 20050802173117.18804.qmail@web33302.mail.mud.yahoo.com
Whole thread Raw
In response to Re: Make year 01/01/0001 but leave timestamp alone  ("Walker, Jed S" <Jed_Walker@cable.comcast.com>)
Responses Strange Error on Table Creation Attempt
Re: boolean or int2
List pgsql-novice
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.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

pgsql-novice by date:

Previous
From: "Walker, Jed S"
Date:
Subject: Re: Make year 01/01/0001 but leave timestamp alone
Next
From:
Date:
Subject: Strange Error on Table Creation Attempt