-----Original Message----- From: Bill Moran [mailto:[EMAIL PROTECTED] Sent: Thursday, 21 August 2008 22:36 To: [EMAIL PROTECTED] Cc: Andrew Maclean; General Subject: Re: [GENERAL] Single character bitfields
In response to "Andrew Maclean" <[EMAIL PROTECTED]>: > 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? > 2) I need to test the field against constants, e.g if the field is > called source then I need tests like: > IF source = 0x10 THEN ... > This does not work in plpgsql functions (source is character(1)), > so what is the solution? I'm not sure I understand what you're trying to accomplish, but there's a bit string type: http://www.postgresql.org/docs/8.3/static/datatype-bit.html -- Bill Moran Collaborative Fusion Inc. http://people.collaborativefusion.com/~wmoran/ [EMAIL PROTECTED] Phone: 412-422-3463x4023 Thankyou for your input. I have decided to use smallint for various reasons. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
