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

On Wed, May 14, 2008 at 10:40 AM, Harald Fuchs
<hari.fuchs@googlemail.com> wrote:
> I think a sequence is much simpler:
>
> create temp sequence tmp;
> select nextval('tmp') as rownum,
>    contactdate
> from
>    myTable
> where
>    contactdate > '2007-06-30 23:59:59'
> order by
>    contactdate;

I used to do it this way myself, but the solution in my previous post
is really worth the trouble.