Uwe Grauer wrote: > Ed Leafe wrote: >> On Feb 21, 2008, at 3:41 PM, Uwe Grauer wrote: >> >>> Please try: >>> select entity_type, entity_fk, count(*) as ent_count from >>> assignment_rotation >>> group by entity_type, entity_fk >>> having count(*) > 1 >> >> Of course, but that's not the question. >> >> The only reason for the 'having' clause is to be able to operate on >> the result set so that aggregate columns that don't exist in the >> sources can be filtered. The result set should have knowledge of >> 'ent_count' at that point (i.e., it works in the 'order by' clause). > > I know that it works in an 'order by' clause. > But this isn't a postgres problem, as the same happens for firebird. > Sorry, i didn't find a clear explained reason for this. > > I'm sure the firebird people will have an answer for this. > I will place a question in the firebird support list.
Here is an answer from the firebird-support group: http://tech.groups.yahoo.com/group/firebird-support/message/92483 Uwe _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/dabo-users/[EMAIL PROTECTED]
