boolean or int2

From: <operationsengineer1(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: boolean or int2
Date: 2005-08-02 17:31:17
Message-ID: 20050802173117.18804.qmail@web33302.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message operationsengineer1 2005-08-02 17:54:45 Strange Error on Table Creation Attempt
Previous Message Walker, Jed S 2005-08-02 17:05:15 Re: Make year 01/01/0001 but leave timestamp alone