In the following query the field 'memid' is varchar(8).
Is the error message below a bug?
select substr(memid,1,1) as memtp, substr(memid,2,4) as newx
from memmast group by memtp, newx
ERROR: column "memmast.memid" must appear in the GROUP BY clause or be used in
an aggregate function
--
Mike Nolan
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
