Re: Add a ROWCOUNT to the output of a select. - Mailing list pgsql-sql

Hi Everyone,

After spending some time searching through our good friend Mr. Google and the mailing list I found a post that provided me with a query that does just what I need.

However, the query takes FOREVER and although this is stated in the original mail I thought I would ask if there was any advice that you might be able to provide to speed things up a little.

And while the query does return over 27,000 rows in my case, I didn't expect it to take 9 minutes and 11 seconds!

Please find the query below - and of course - thanks in advance for any assistance you might be able to provide me with!

select
   (select
        count(*)
    from
        myTable as myCount
    where
        myCount.contactdate <= myTable.contactdate
   ) as rownum,
   contactdate
from
   myTable
where
   contactdate > '2007-06-30 23:59:59'
order by
   contactdate;