On Wed, Feb 12, 2003 at 23:21:18 +0100,
Nicholas Allen <nallen(at)freenet(dot)co(dot)uk> wrote:
> However, if I try to count the records using the count(*) function I get the following error.
>
> ERROR: Attribute vu_tbl_user_all_s.s_surname must be GROUPed or used in an aggregate function
>
> Surely, if postgres can execute the query it should also be able to count the rows that would be returned in the query? Is this a bug in Postgres and is there a work around? I am using Postgres 7.3.
If you are using count you probably don't want to be returning surnames, just
the count.