MySQL Forums
Forum List  »  Informix

Re: What does columnname::datatype do in a where clause
Posted by: J Jorgenson
Date: August 02, 2005 09:35AM

Your where clause would be translated into:

WHERE Reseler_Profile.Status_ID = Reseller_Status.Status_ID AND
(param_Reseller_Id IS NULL or CAST(Reseler_Profile.Reseller_Id AS CHAR(4)) LIKE param_Reseller_Id)

The ::CHAR(4) was replaced with CAST( xxx AS CHAR(4))

However, I recommend to avoid a CAST in a situation where you'll be increasing the field size, or where performance is an absolute must. It would be better to reduce the 'other' field's size rather than increase a size.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: What does columnname::datatype do in a where clause
6231
August 02, 2005 09:35AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.