Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!ncar!asuvax!anasaz!john From: john@anasaz.UUCP (John Moore) Newsgroups: comp.databases Subject: Re: RDBMS sux, array/vector datatypes Message-ID: <889@anasaz.UUCP> Date: 10 Nov 89 13:56:21 GMT References: <4022@rtech.rtech.com> Reply-To: john@anasaz.UUCP (John Moore) Distribution: na Organization: Anasazi Inc, Phoenix AZ Lines: 23 In article <4022@rtech.rtech.com> robf@squid.UUCP (Robert Fair (ECSC Tech Support)) writes: ]Recent posters have commented about the lack of array/vector datatypes ]in RDBMS currently available. This is actually an *implementation* ]restriction rather than an inherent drawback of RDBMS or SQL. ] ]There's no reason why an RDBMS cannot support an arry/vector datatype, ]in fact (plug coming) INGRES just announced a new "Object Management" ]extension to INGRES R6 which allows you to create pretty much any kind ]of datatype you like, including arrays and vectors. You can also create ]operators and functions to work with these datatypes - for example if ]you want (vector + vector) to work a specific way just define the ]appropriate operations for '+'. Once a datatype/operators/functions ]has been defined you can access it through SQL just like any regular ]"built-in" datatype. This sounds great! Now, when can we get it into a standard so that I can write an application using it and not be forever beholden to the vendor of that particular flavor of OODBMS? -- John Moore (NJ7E) mcdphx!anasaz!john asuvax!anasaz!john (602) 861-7607 (day or eve) long palladium, short petroleum 7525 Clearwater Pkwy, Scottsdale, AZ 85253 The 2nd amendment is about military weapons, NOT JUST hunting weapons!