| From: | Ragnar <gnari(at)hive(dot)is> |
|---|---|
| To: | Alban Hertroys <alban(at)magproductions(dot)nl> |
| Cc: | Richard Ollier <r(dot)ollier(at)tequila(dot)co(dot)jp>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Table design - unknown number of column |
| Date: | 2006-11-09 10:10:40 |
| Message-ID: | 1163067040.8950.233.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On fim, 2006-11-09 at 10:56 +0100, Alban Hertroys wrote:
> Richard Ollier wrote:
> > For a project I have a table containing products and flags.
> > The columns of this table are of 2 kinds :
> > - Not null data (id, column1, column2)
> > - Flags (100 different flags set to 1 or 0)
> >
> > Over the time the number of flag will increase from 100 to 200 or more.
>
> Having 200 flags as 200 fields... Writing queries on that is going to be
> painful.
>
> I would probably look at bitwise operations, although 200 bits is quite
> a bit larger than a bigint. Maybe an array of ints would work...
maybe the BIT VARYING datatype could be useful.
http://www.postgresql.org/docs/8.1/interactive/datatype-bit.html
gnari
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2006-11-09 10:16:06 | Re: Can PostgreSQL notify a client that a trigger has fired? |
| Previous Message | Alban Hertroys | 2006-11-09 09:56:58 | Re: Table design - unknown number of column |