On Thu, Aug 26, 2010 at 12:28 AM, <wei725@xxxxxxxxx> wrote: > You are right. I typed the message in hurry before I left home this morning. It is the boolean type. Thanks for your suggestion. The NULL value may not work for jdbc. On the application level, a fixed set of constants is used to represent the three status, which are converted into an integer. TBH, you are probably best off taking those constants and writing them directly into the database (unless they happen to be dictionary pages), and applying a check constraint or using referential integrity to match against the known list. merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
