On Oct 15, 2011, at 3:24 PM, Krishnakant Mane wrote:
> On 15/10/11 22:17, Michael Bayer wrote:
>
>> that sounds like an issue in the procedure itself, such as running it on the
>> wrong database, or the wrong "groups" table otherwise. there could be many
>> schemas/databases that contain a "groups" table. Get the procedure to
>> work with psql first using the identical login information.
>>
>>
>>
>
> I got the result but without using func.
> when I did res = engine.execute("select * from getGroupByCode(1)) I got the
> results.
> But func.execute still seems to have a problem.
> happy hacking.
> Krishnakant.
should make no difference, but your exact SQL:
from sqlalchemy import func, select
engine.execute(select(['*']).select_from(func.getGroupByCode(1))).scalar()
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
