Archives of the TeradataForum

Message Posted: Fri, 26 Mar 2004 @ 20:36:55 GMT

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

Uh...yeah. I don't see anything uncertain if you just recognize that the wording in the documentation is wrong. It's an open interval...case closed. (Open intervals are defined as all numbers between 2 endpoints except for the endpoints themselves.)

Proof: You can't get 0% of the rows nor can you get 100% (those are the 2 endpoints). You can "cheat" by saying "sel * from x sample 0", but then you are no longer using the "fractional_description" syntax but rather the "count_description" syntax. Note that "sel * from x sample 0.0" returns an error. The only "buggy" thing about this is the fact that "sel * from x sample 1.0" is parsed as "count_description" syntax instead of "fractional_description" syntax. Anyway, who cares. The guy can't get what he wants directly. Nuff said.

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