>>>>>>>>>>>> Thomas Dudziak wrote (2005-12-18 17:09:35): > On 12/18/05, Bernt M. Johnsen <[EMAIL PROTECTED]> wrote: > > > You're just missing a small detail: > > > > select count(*) from (select distinct person_id, project_id from > > person_project) as t(a,b); > > Yup, thanks, that works! > But is there any chance for support for > > SELECT COUNT(DISTINCT person_id, project_id) FROM person_project ? > > would make things a lot easier for us :-)
Don't think many databases has implemented COUNT(<row value expression>) although it has been in the SQL standard since '92. COUNT(DISTINCT col) works, though > regards, > Tom -- Bernt Marius Johnsen, Database Technology Group, Sun Microsystems, Trondheim, Norway
pgpunCWEXv7ze.pgp
Description: PGP signature
