[RDBO] redundant rows from queries with multiple one to many relationships

2008-01-31 Thread James Masters
Dear Rosers, I have never fully understood the implications of this message: WARNING: Fetching sub-objects via more than one one to many relationship in a single query may produce many redundant rows, and the query may be slow I have avoided doing such queries until now but now I have reached

Re: [RDBO] Candidate for RDBO?

2008-01-31 Thread John Siracusa
On Jan 30, 2008 9:23 PM, Fred Cox [EMAIL PROTECTED] wrote: I've got a Postgresql DBI select: SELECT COUNT(*) AS voters, SUM(liked) AS liked, SUM(liked) / CAST( COUNT(*) AS real ) AS ratio FROM review_votes WHERE reviewid=? that works well, but I wasn't sure whether it would be practical to

Re: [RDBO] Problem using check_in with a varchar column

2008-01-31 Thread John Siracusa
On Jan 31, 2008 3:44 PM, Sam Tregar [EMAIL PROTECTED] wrote: $meta-column(status = {type = 'varchar', default = 'normal', length = 32, check_in = ['good', 'normal',

Re: [RDBO] Problem using check_in with a varchar column

2008-01-31 Thread Sam Tregar
On Jan 31, 2008 3:53 PM, John Siracusa [EMAIL PROTECTED] wrote: I'm assuming it only produces that error when it tries to emit the Perl code for that class into a .pm file, right? Yes, that's it. I was using the emitted Perl code to debug my auto-init setup. If so, I think I have the fix