pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Data Type for "flags"
2+ messages / 1 participants
[nested] [flat]

* Data Type for "flags"
@ 2007-05-16 09:10  李彦 Ian Li <liyan82@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: 李彦 Ian Li @ 2007-05-16 09:10 UTC (permalink / raw)
  To: pgsql-php

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Data Type for "flags"
@ 2007-05-16 09:29  李彦 Ian Li <liyan82@gmail.com>
  parent: 李彦 Ian Li <liyan82@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: 李彦 Ian Li @ 2007-05-16 09:29 UTC (permalink / raw)
  To: pgsql-php; +Cc: becker@adocom.de

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
> 




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2007-05-16 09:29 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-05-16 09:10 Data Type for "flags" 李彦 Ian Li <liyan82@gmail.com>
2007-05-16 09:29 ` 李彦 Ian Li <liyan82@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox