Skip site navigation (1) Skip section navigation (2)

Re: Data Type for "flags"

From: 李彦 Ian Li <liyan82(at)gmail(dot)com>
To: pgsql-php(at)postgresql(dot)org
Cc: becker(at)adocom(dot)de
Subject: Re: Data Type for "flags"
Date: 2007-05-16 09:29:22
Message-ID: 464ACEF2.2000203@gmail.com (view raw or flat)
Thread:
Lists: 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
> 


In response to

pgsql-php by date

Next:From: Colin RossDate: 2007-05-23 20:10:42
Subject: Application Design: Where to implement historical revisions of objects
Previous:From: 李彦 Ian LiDate: 2007-05-16 09:10:48
Subject: Data Type for "flags"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group