On Thu, Aug 21, 2008 at 12:56 PM, Joshua Drake <jd@xxxxxxxxxxxxxxxxx> wrote: > On Thu, 21 Aug 2008 12:40:29 +1000 > "Andrew Maclean" <andrew.amaclean@xxxxxxxxx> wrote: > >> I have a large database and I want to have several fields (among many) >> that are single character fields (in fact they are bitfields). >> >> 1) Is char(1) the most efficient way to store these fields? If not >> what is better? > > boolean? > > Joshua D. Drake > > -- > The PostgreSQL Company since 1997: http://www.commandprompt.com/ > PostgreSQL Community Conference: http://www.postgresqlconference.org/ > United States PostgreSQL Association: http://www.postgresql.us/ > Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate > > > I wouldn't be happy doing this because I prefer treating boolean data types as only TRUE or FALSE. Is char(1) one byte in size? -- ___________________________________________ Andrew J. P. Maclean Centre for Autonomous Systems The Rose Street Building J04 The University of Sydney 2006 NSW AUSTRALIA Ph: +61 2 9351 3283 Fax: +61 2 9351 7474 URL: http://www.acfr.usyd.edu.au/ ___________________________________________
