php/pgsql coding question...

From: <operationsengineer1(at)yahoo(dot)com>
To: operationsengineer1(at)yahoo(dot)com, PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: php/pgsql coding question...
Date: 2005-02-25 22:23:53
Message-ID: 20050225222353.62855.qmail@web52403.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message operationsengineer1 2005-02-25 22:27:01 Re: pgadmin3 column edit question
Previous Message Oisin Glynn 2005-02-25 22:16:47 Re: pgadmin3 column edit question