[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

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] select time

2006-06-14 Thread Jonathan Vanasco
is there a trivial way to get the time in rose -- from the database that you are connected to? i really just need a wrapper for "SELECT NOW()" - i haven't seen it in the docs, but rose seems to have everything in there, so i figure if i can think of something, its already been done.

Re: [RDBO] select time

2006-06-14 Thread John Siracusa
On 6/14/06, Jonathan Vanasco <[EMAIL PROTECTED]> wrote: > is there a trivial way to get the time in rose -- from the database > that you are connected to? > > i really just need a wrapper for "SELECT NOW()" - i haven't seen it > in the docs, but rose seems to have everything in there, so i > fig

Re: [RDBO] select time

2006-06-14 Thread Jonathan Vanasco
a- thanks for the code, using it On Jun 14, 2006, at 10:47 AM, John Siracusa wrote: > That's kind of an odd thing to want :) Can't you get your local time > and adjust it to the time zone of the db, if necessary? b - not really for 2 reasons - one normal, the other odd clustering: time