Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBIGbim93530 for ; Tue, 18 Dec 2001 11:37:44 -0500 (EST) (envelope-from josh@agliodbs.com) Received: from [209.10.40.250] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.4.7) with HTTP id 531103; Tue, 18 Dec 2001 08:37:46 -0800 From: "Josh Berkus" Subject: Re: Operation on bit strings with different length To: S P Arif Sahari Wibowo , X-Mailer: CommuniGate Pro Web Mailer v.3.4.7 Date: Tue, 18 Dec 2001 08:37:46 -0800 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Archive-Number: 200112/90 X-Sequence-Number: 2633 Arif, For future notice, the NOVICE list is the appropriate place for this type of question. > Do you know how to operate (AND, OR, etc.) on bit strings with > dynamically different length? It is dynamic, means the length won't > be > determined until run time. > Is there any function to extend the length of a bit string to a > certain > length? PostgreSQL is currently (as far as I know) lacking a good set of bitwise data types and operators. If you really need to use them, I suggest that you construct them -- Postgres allows you to build your own data types, and operators for those data types. It's a somewhat labor-intensive process. Most of us don't have much use for bitwise operations in the database, because the essential intent of a bitwise number is to store several different pieces of data in the same number. This goes against relational principles, which say that each field should be "atomic"; that is, containing one and only one piece of information. If, however, you are interacting with the MS API, I can see why you would need bitwise logic. So my suggestions are: 1. Create your own data types and operators per paragraph 1; 2. Just store the integer in Postgres, and do your bitwise logic in your interface/middleware language. -Josh Berkus -Josh Berkus ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco