projects
/
dbsrgits/DBIx-Class.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
cookbook tweak for count distinct
[dbsrgits/DBIx-Class.git]
/
lib
/
DBIx
/
Class
/
Manual
/
Cookbook.pod
diff --git
a/lib/DBIx/Class/Manual/Cookbook.pod
b/lib/DBIx/Class/Manual/Cookbook.pod
index
574a8e1
..
b13b05a
100644
(file)
--- a/
lib/DBIx/Class/Manual/Cookbook.pod
+++ b/
lib/DBIx/Class/Manual/Cookbook.pod
@@
-279,7
+279,7
@@
any of your aliases using either of these:
my $count = $rs->count;
# Equivalent SQL:
- # SELECT COUNT( DISTINCT( me.name ) ) FROM artist me
+ # SELECT COUNT( * ) FROM (SELECT me.name FROM artist me GROUP BY me.name) count_subq:
=head2 Grouping results