Archives of the TeradataForum

Message Posted: Wed, 24 Jan 2001 @ 17:41:54 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Anybody want to take a poll? My vote is leave it that way. I've used Multiset tables, as well as tables with duplicate rows in other databases. In order to change, delete or even read ONLY ONE of those rows, it requires:

A) Knowing the ^%&$&% rowid and working with rowid, or

B) Reading all the dups, deleting all of them and then either putting back all the "others" you want (the delete option) or updating the one you want and writing it and all it's brothers.

And all this for what? Because someone hasn't adequately defined the table, ultimately!

Ok, I'm done ranting.

iv

Frank C. Martinez IV

	<Prev	Next>		<<First	<Prev	Next>	Last>>