> 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.