Re: select count(*)

If you INSERT INTO mytable.mycolumn SELECT COUNT(*) ... and mycolumn is decimal, obviously the result is decimal, but i think it has no sense, because the resulting value of this SELECT has only an integer value in all of the cases. --- Thanh <tqma@my-deja.com> escribi': > I understand that 'select count(*)' now returns > decimal. > However, I was told that this violate SQL standard. > Is there > any true to this ? > > Thanks, > T. > > > Sent via Deja.com http://www.deja.com/ > Before you buy. > ===== ______________________________________ Luis Carlos D'az Otero ALCANOS DE COLOMBIA S.A. E.S.P Carrera 9 # 7-25 Neiva (Huila (Colombia)) __________________________________________________ Do You Yahoo!? Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/