Re: [RDBO] Using stored procedures

2006-06-15 Thread Lucian Dragus
Thank you for your prompt answer :) > I'm surprised that ever worked since it's not strictly supported. The > suggested alternative is to make a VIEW on your stored_proc() and then > point RDBO at that view. The parameters for my stored procedure are indicating the level of agregation and the f

Re: [RDBO] Using stored procedures

2006-06-14 Thread John Siracusa
On 6/14/06 6:42 AM, Lucian Dragus wrote: > In Postgresql I'm having a stored procedure, which is returning agregate data, > based on passed parameters. In front on that is a Rose::DB::Object subclass > and at each invocation of a 'select' method I'm changing the table name to > include the paramete

[RDBO] Using stored procedures

2006-06-14 Thread Lucian Dragus
Hi, In Postgresql I'm having a stored procedure, which is returning agregate data, based on passed parameters. In front on that is a Rose::DB::Object subclass and at each invocation of a 'select' method I'm changing the table name to include the parameters, like: $meta->table("stored_p