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