Re: [GENERAL] distinct values and count over window function

2012-11-27 Thread Rodrigo Rosenfeld Rosas
Em 27-11-2012 19:50, David Johnston escreveu: From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Rodrigo Rosenfeld Rosas Sent: Tuesday, November 27, 2012 4:23 PM To: pgsql-general@postgresql.org Subject: [GENERAL] distinct values and count over

Re: [GENERAL] distinct values and count over window function

2012-11-27 Thread David Johnston
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Rodrigo Rosenfeld Rosas Sent: Tuesday, November 27, 2012 4:23 PM To: pgsql-general@postgresql.org Subject: [GENERAL] distinct values and count over window function Hello, this is my first post to

[GENERAL] distinct values and count over window function

2012-11-27 Thread Rodrigo Rosenfeld Rosas
Hello, this is my first post to this particular list (I've also posted to performance list a while ago to report a bug). I generate complex dynamic queries and paginate them using "LIMIT 50". I have a need for implementing some statistics for the results as well and I'd like to know if I can a