db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Scott Eade <se...@backstagetech.com.au>
Subject Re: Postgres 7.3 joins and limit / offsets
Date Thu, 13 Mar 2003 00:23:01 GMT
See: 
http://nagoya.apache.org/wiki/apachewiki.cgi?TorqueProjectPages/PostgreSQLFA
Q

And: http://scarab.werken.com/scarab/issues/id/TRQS121

Scott
-- 
Scott Eade
Backstage Technologies Pty. Ltd.
http://www.backstagetech.com.au
.Mac Chat/AIM: seade at mac dot com


On 12/03/2003 6:07 PM, "Matt Hughes" <mhughe@ucalgary.ca> wrote:

> 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...


Mime
View raw message