Hello, On Tue, Nov 16, 2010 at 01:52:42PM -0800, Ian wrote: > The proper way to get the number of rows is to > use the COUNT aggregate function, e.g., "SELECT > COUNT(*) FROM TABLE1", which will return a > single row with a single column containing the > number of rows in table1.
It's better to select count(1) instead of count(*). The latter may skip rows consisting entirely of NULLs IIRC. -- With best regards, xrgtn -- http://mail.python.org/mailman/listinfo/python-list
