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