Hello,
Please copy me on replies as I'm not subscribed to this list.
I'm working on an application using psycopg2 2.2.1. Regarding stored
procedures, I'm seeing some odd behavior. I am calling the procedure like:
SELECT sp_foobar(1, 2, 3);
In this case, the stored procedure is declared to return a "setof" a
custom type, and it returns using "RETURN QUERY SELECT ...".
I would expect the rows to come back from cursor.fetchall() in this
structure:
[(1,2),(3,4),(5,6)]
But they are returned like this:
[('(1,2)'),('(3,4)'),('(5,6)')]
This makes no sense to me. Is this expected/documented behavior?
--
Chris Howie
http://www.chrishowie.com
http://en.wikipedia.org/wiki/User:Crazycomputers
If you correspond with me on a regular basis, please read this document:
http://www.chrishowie.com/email-preferences/
PGP fingerprint: 2B7A B280 8B12 21CC 260A DF65 6FCE 505A CF83 38F5
------------------------------------------------------------------------
IMPORTANT INFORMATION/DISCLAIMER
This document should be read only by those persons to whom it is
addressed. If you have received this message it was obviously addressed
to you and therefore you can read it.
Additionally, by sending an email to ANY of my addresses or to ANY
mailing lists to which I am subscribed, whether intentionally or
accidentally, you are agreeing that I am "the intended recipient," and
that I may do whatever I wish with the contents of any message received
from you, unless a pre-existing agreement prohibits me from so doing.
This overrides any disclaimer or statement of confidentiality that may
be included on your message.