Re: A thought on Index Organized Tables

Andrew Dunstan wrote:
> Gokulakannan Somasundaram wrote:
>>          I looked at the postgres nbtree code. From my analysis(which
>> might be wrong!), we can implement IOTs, provided we make a decision
>> on broken data types issue.
> 
> I am not familiar with this term "broken data types", and I just looked
> for it in the source code and couldn't find it.
> 
> What exactly are you referring to?

I believe he's referring to the fact that once a key is inserted to an
index, it might not be possible to re-find it, if the datatype is broken
in such a way that e.g comparison operator returns a different value.
For example, today "1 < 2" returns true, but tomorrow it returns false.

The decision on that is that you need to deal with it.

--  Heikki Linnakangas EnterpriseDB   http://www.enterprisedb.com