Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0HGdv033087 for ; Wed, 17 Jan 2001 11:39:58 -0500 (EST) (envelope-from josh@agliodbs.com) Received: from [208.59.253.44] (HELO agliodbs.com) by davinci.ethosmedia.com (CommuniGate Pro SMTP 3.3) with ESMTP id 1178303 for pgsql-sql@postgresql.org; Wed, 17 Jan 2001 08:39:53 -0800 Message-ID: <3A65CA05.39C04CEE@agliodbs.com> Date: Wed, 17 Jan 2001 08:36:21 -0800 From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions X-Mailer: Mozilla 4.73 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: sqllist Subject: Re: Re: Boolean and Bit References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200101/192 X-Sequence-Number: 856 Josh Berkus wrote: > Well, yes. This is beacause BLOBs are NOT part of the SQL > standard and IMHO a bad idea relationally; thus their > implementation is entirely proprietary to the RDBMS. The > solution is not to use BLOBs. Ooops. Let me re-state: This is because the *implementation* of BLOBS is not defined in the SQL standard, and BLOBs are IMHO a bad idea for relational database design, as they violate Codd's Rules. Thus the implementation of, anf functions and operators for BLOBs are entirely proprietary to the RDBMS platform. The solution to this is not to use BLOBs, but rather to use file system handles for the location of the binary data on the server. This way, all you need is DOS-to-UNIX and UNIX-to-DOS translation for the filesystem handles, something easily accomplished through string-manipulation functions or stored procedures. -Josh Berkus -- ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 436-9166 for law firms, small businesses fax 436-0137 and non-profit organizations. pager 338-4078 San Francisco