Criteria's addJoin does inner joins, but is it possible to do left or right joins without resorting to the Query object?
The PostgreSQL syntax in BasePeer.java seems to be incorrect; the offset and limit are two seperate keywords, not parameters to LIMIT. Is this a bug or is there some reason for it? If it's I bug, I'll send a patch, but do other databases use DB.LIMIT_STYLE_POSTGRES? If so, perhaps a third category for offset and limit syntax should be added... -- Matt Hughes + [EMAIL PROTECTED] + http://www.enel.ucalgary.ca/~hughes + "Were there monkeys? Some terrifying space monkeys maybe got loose?" --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
