Re: Column question

hey.

perhaps you could use the datatype "boolean". where true can be Y and
false can be N.

possibly something like:

CREATE TABLE tablename
(denied boolean DEFAULT true);

i cannot try it out here, but it might work
--
john

Sometime in June Williams, Travis L, NPONS assaulted keyboard and produced...

|I'm wanting to make a column named "denied" with a default of "Y" and only
|be able to have two possible values "Y" or "N".. any help..!!?? Thanks in
|advance..
|
|Travis
|
|---------------------------(end of broadcast)---------------------------
|TIP 5: Have you checked our extensive FAQ?
|
|http://www.postgresql.org/users-lounge/docs/faq.html
|