Re: (domain support) Re: theory and practice: ying and yang

DM Unseen wrote:
> MS UDT's are probably limited, although I haven't bothered to
> investgate exactly how. I suspect MS UDT's need to be small and there
> needs to be a certain mapping to an integer domain(for serialization
> purposes) so types like POINT(X,Y), Complex numbers and Periods could
> work. IMO an option to implement UDT properties in seperate fields
> would have been more welcome than the ablity to customize
> serialization.

Should a DBMS with an integer domain be able to optimise a query like this? (where i is a column of type "integer"):

SELECT * FROM tbl WHERE i*i < 0

Or would we expect it to try squaring i for each row in turn?

Paul. Received on Tue May 31 2005 - 17:59:50 CEST