Re: Prob with COUNT in a VIEW

In article <E71JKA.MG9@nonexistent.com>, Jacob Salomon <jake@apparel.net> writes >The syntax COUNT (tt.ladeeinheit) struck me as problematic. I seem to >recall (with my somewhat flakey memory ;-) that thuse used to be an >illegal syntax in previous versions (going back to 4.x here) and this >has always made sense to me. After all, the number of occurrences of any >column [in the group] *must* match the number of rows in the group. If >the syntax is now legal, it has the taste of an afterthought. Correct and agreed. Informix 4 uses to allow update tab1 set (tab1.col1,tab1.col2) = (value1,value2) ^ ^ | | Extra copies of tablename and a similar thing for inserts. This is no longer legal syntax. Tr changing it to count(ladeeinheit) ....assuming the column name is unique. > >However, the syntax COUNT (unique tt.ladeeinheit) was legal even in 4.0! >Perhaps that is what you were looking for. -- David Williams