php/pgsql coding question... - Mailing list pgsql-novice

From
Subject php/pgsql coding question...
Date
Msg-id 20050225222353.62855.qmail@web52403.mail.yahoo.com
Whole thread Raw
In response to pgadmin3 column edit question  (<operationsengineer1@yahoo.com>)
List pgsql-novice
i am using a radio button set up in order to choose
the quality standard to which a product will be
inspected.

i'm thinking the easiest way to do this is to grab the
value of the radio button after form submission and
then store it in my pgsql db in a column with datatype
varchar(7).

the other option that i can't disregard right now is
to use the value "0" to represent standard "A" and "1"
to represent value "B".  i was originally thinking
about using boolean, but then i considered the
possibility that a third quality standard could be
added at some later date.

anywho, is either method superior to other?  i guess
the latter method stores less data, but in this case,
the number of product rows will only be a couple
hundred.  maybe i should just go with the latter
method on a general efficiency principle.

if i go the latter route, should i use int2 as the
datatype of the column (used to store "0", "1" and
potentially "2", etc... at a later date?

tia...



__________________________________
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.
http://promotions.yahoo.com/new_mail

pgsql-novice by date:

Previous
From: "Oisin Glynn"
Date:
Subject: Re: pgadmin3 column edit question
Next
From:
Date:
Subject: Re: pgadmin3 column edit question