Changes have been made in Git for this ticket:

[jan] Add Horde_Rdo_Query#distinct() (Request #10535).

  2 files changed, 13 insertions(+), 9 deletions(-)
http://git.horde.org/horde-git/-/commit/1445e10b285786be126616888f7fbb1b1cfdffde

Changes have been made in Git for this ticket:

Optimize request 10535.

  1 files changed, 8 insertions(+), 13 deletions(-)
http://git.horde.org/horde-git/-/commit/206a971165a455b00ff27ad0d54bdbbf42725813

Changes have been made in Git for this ticket:

Added sql DISTINCT query feature.
Request: 10535
Signed-off-by: Jan Schneider <jan@horde.org>

  1 files changed, 29 insertions(+), 1 deletions(-)
http://git.horde.org/horde-git/-/commit/16e4609273a3a1df23f585b4a7527146b03d83a0

My bad. I didn´t notice there was a magic __call method on 
Adapter/Base delegating calls to the Schema.

Attached is another patch.

The adapter->distinct() method should be called with proper arguments, 
so it knows when ORDER BY clause is also present in the query (which 
changes the DISTINCT clause a little bit for postgresql, for example).

http://dev.horde.org/api/framework/Db/Db/Adapter/Horde_Db_Adapter_Base_Schema.html#distinct

But it's really as easy as using $this->mapper->adapter->distinct() in 
Horde_Rdo_Query.

Hum, now I´m confused. Couldn´t find any distinct related method here: 
http://dev.horde.org/api/framework/Db/

I guess the solution is more complex than I was thinking. Anyway, I 
suggest leaving this ticket open for future implementation.

Sorry that I didn't catch that earlier: you need to use Horde_Db's 
distinct() method to add the DISTINCT to the query.

Attached follows another patch.

$query->distinct() or $query->distinct(true) // Turns on distinct query
$query->distinct(false) // Turns off distinct query

Looks good, but should also contain an option to unset the distinct 
flag, e.g. adding a boolean argument to the distinct() method that 
defaults to true.

Zitat von Luis Felipe Marzagao/Andamentos <lfbm.andamentos@gmail.com>:

That's more like a hack. We should add some feature to Horde_Rdo_Query 
instead that makes a query DISTINCT.

Jan.

- - - - - - - - - -

Attached is a suggestion.

Luis Felipe