php/pgsql coding question...

Поиск
Список
Период
Сортировка
От
Тема php/pgsql coding question...
Дата
Msg-id 20050225222353.62855.qmail@web52403.mail.yahoo.com
обсуждение исходный текст
Ответ на pgadmin3 column edit question  (<operationsengineer1@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: "Oisin Glynn"
Дата:
Сообщение: Re: pgadmin3 column edit question
Следующее
От:
Дата:
Сообщение: Re: pgadmin3 column edit question