[Pypgsql-users] strange pypgsql return value

[Tom J. <tje...@de...>]

hello all,
we're migrating away from pygresql and i'm evaluating pypgsql along with
psycopg. i found something troubling with both adapters.  when we
execute a select of this form:
  select count(myfield) from mytable where mykey = myvalue
and there aren't any rows that match then we get a TypeError exception
(psycopg returns ((None,)) which is almost as bad <wink>).  Similarly i
was getting the same exception on sums.  Now i expected and got in
pygresql a return of ((0,)).

is anyone else seeing this or i am missing something here

-- 

Tom Jenkins
Development InfoStructure
http://www.devis.com