increment counter in VIEW

From: Oleg <evdakov(at)iwg(dot)uka(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: increment counter in VIEW
Date: 2006-07-12 11:14:55
Message-ID: 44B4D9AF.6020208@iwg.uka.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

Thanks a lot in advance
Oleg

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Richard Broersma Jr 2006-07-12 12:05:30 Re: increment counter in VIEW
Previous Message Ilias Goudaropoulos 2006-07-12 08:46:55 Installer errors on WinXP SP2