Re: count and actual data

At 5:10 +0300 on 4/5/98, Richard Lynch wrote:

> Now, I really want the result from the first query, *AND* the count from
> the second query.
>
> select name, count(name) from users;
>
> would be fine, even if it did give me the count too many times, but it
> won't work.
>
> So. how does one get both the data and the count as results in table format
> from a query?

Define a function, and select both it and the data...

CREATE FUNCTION cnt_usr() RETURNS int4
AS 'SELECT COUNT(name) FROM users'
LANGUAGE 'sql';

SELECT name, cnt_usr()
FROM users;

You do realize, however, that it will do the counting over and over for
each line?

Herouth