Re: [RDBO] odd select question

2006-08-03 Thread John Siracusa
On 8/3/06, Jonathan Vanasco <[EMAIL PROTECTED]> wrote: > Just wondering, does this create a mysql distinct or a postgres/ > oracle/ansi distinct? i was shocked and awed when migrating away from > mysql that distinct is an entirely different beast on just about > every other RDBMS It just literally

Re: [RDBO] odd select question

2006-08-03 Thread Jonathan Vanasco
> stored_information. Check out the "fetch_only" and "distinct" > parameters to > get_objects() > > http://search.cpan.org/dist/Rose-DB-Object/lib/Rose/DB/Object/ > Manager.pm#dis > tinct > http://search.cpan.org/dist/Rose-DB-Object/lib/Rose/DB/Object/ > Manager.pm#fet > ch_only > > The fetch_

Re: [RDBO] odd select question

2006-08-03 Thread John Siracusa
On 8/2/06 11:51 PM, Jonathan Vanasco wrote: > b) make a manager sub on stored_information__name that uses a join > against stored_information, but does not retrieve the info in it Since you always have to fetch something from the "main" (t1) table when using get_objects(), this is the one you wan