Re: Data Type for "flags" - Mailing list pgsql-php

From 李彦 Ian Li
Subject Re: Data Type for "flags"
Date
Msg-id 464ACEF2.2000203@gmail.com
Whole thread Raw
In response to Data Type for "flags"  (李彦 Ian Li <liyan82@gmail.com>)
List pgsql-php
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
>


pgsql-php by date:

Previous
From: 李彦 Ian Li
Date:
Subject: Data Type for "flags"
Next
From: "Colin Ross"
Date:
Subject: Application Design: Where to implement historical revisions of objects