Re: increment counter in VIEW

> Dear All,
> Does anybody know how to add increment counter column to VIEW? To get
> something like this
>
> cntrColumn | anotherCol
> ------------------------
> 1                 |  val1
> 2                 |  val2
> 3                 |  ..
> 4                 |
>
> The best if this counter will be executed together with sort to ensure
> that sertain record gets always the same Counter value.

I am not sure if generate_series is what you want.
http://www.postgresql.org/docs/8.1/interactive/functions-srf.html

Regards,
Richard Broersma Jr.