Postgres Pro
Downloads
Home   >   mailing lists

increment counter in VIEW - Mailing list pgsql-novice

From Oleg
Subject increment counter in VIEW
Date
Msg-id 44B4D9AF.6020208@iwg.uka.de
Whole thread Raw
Responses Re: increment counter in VIEW
List pgsql-novice
Tree 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.

Thanks a lot in advance
Oleg

pgsql-novice by date:

Previous
From: Ilias Goudaropoulos
Date:
Subject: Installer errors on WinXP SP2
Next
From: Richard Broersma Jr
Date:
Subject: Re: increment counter in VIEW