On Feb 14, 2008, at 12:35 PM, John Keith Hohm wrote:

>
>> Stored procedures can also be called simply by name, omitting the  
>> "EXEC":
>>
>>    EXEC procedure_foo <parms>
>>              or
>>    procedure_foo  <parms>
>
> True, but as you suggested it's hardly a burden to type the EXEC.
>
>> and I believe they can also be called from within a subquery:
>>
>>    select * from (procedure_foo)
>
> That would be lovely, but I can find no way to wrap a procedure in a
> select.  If it were possible I could have just rewritten the procedure
> call as a select and matched the existing regexp.

you can do that as select(["*"]).select_from(func.procedure.foo()) .

--~--~---------~--~----~------------~-------~--~----~
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 [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to