All,

A shortcut to getting your "count by OS" in one command:

controlsmartdb=#   select os_name,count(*)
controlsmartdb-#     from user_info
controlsmartdb-# group by os_name
controlsmartdb-# order by os_name;
     os_name     | count
----------------+-------
  ALL            |     1
  LINUX          |     4
  MAC_ALL        |     1
  MAC_OSX        |    11
  WINDOWS_2K     |     4
  WINDOWS_MCE_XP |    90
  WINDOWS_PRO_XP |   454
  WINDOWS_TPC_XP |     2
  WINDOWS_XP     |     2
  WINDOWS_XP_MCE |     1
(10 rows)

Kurt



At 10:19 AM 1/18/2007, Howard Speight wrote:

>controlsmartdb=# select count(*) from user_info WHERE
>os_name='WINDOWS_PRO_XP';
>  count
>-------
>   2903
>(1 row)



____________________________________________________
Kurt E. Huenemann '83
Assoc. Vice President for Information Resources
Asst. Professor of Computer Science
Heidelberg College
310 East Market Street
Tiffin, OH 44883

Internet: [log in to unmask]
Fax:      419-448-2176
Voice:    419-448-2351

Engaging Students.  Creating futures.
____________________________________________________