Re: Compare rows

Greg Spiegelberg wrote:

> Josh Berkus wrote:
> 
>>
>> As you can see, the NULLs are not stored, making this system much more 
>> efficient on storage space.
>>
>> Tommorrow I'll (hopefully) write up how to query this for 
>> comparisons.   It would help if you gave a little more details about 
>> what specific comparison you're doing, e.g. between tables or table to 
>> value, comparing just the last value or all rows, etc.
>>
> 
> Got it.  I can see how it would be more efficient in storing.  At this
> point it would require a lot of query and code rewrites to handle it.
> Fortunately, we're looking for alternatives for the next revision and
> we're leaving ourselves open for a rewrite much to the boss's chagrin.

I'm not sure about the save in storage. See the Hannu Krosing
arguments.


Regards
Gaetano Mendola