Thread: Data Type for "flags"

Hello all:
    I am new to PHP and PostgereSQL with some former experiences of ASP
and MSSQL. My question is when I want to represent different types
of object, or different status of object in my application, e.g.
class of users, I used to use tinyint in MSSQL. But I found there is
no such thing in PGSQL, so what should I use instead? integer, bytea
,or bit(n)? I think integer will be the most convenient to use,
isn't it?

Regards,
Ian

Oops... I've just omitted the smallint type at the beginning of the
document. Thanks anyway!

李彦 Ian Li wrote:
> Hello all:
>     I am new to PHP and PostgereSQL with some former experiences of ASP
> and MSSQL. My question is when I want to represent different types of
> object, or different status of object in my application, e.g. class of
> users, I used to use tinyint in MSSQL. But I found there is no such
> thing in PGSQL, so what should I use instead? integer, bytea ,or bit(n)?
> I think integer will be the most convenient to use, isn't it?
>
> Regards,
> Ian
>