Data Type for "flags"

李彦 Ian Li <[email protected]>
Newsgroups gmane.comp.db.postgresql.php
Message-ID <[email protected]>
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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.