Automatic row numbering / sequence in view ?

From: Arnaud Lesauvage <thewild(at)freesurf(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: Automatic row numbering / sequence in view ?
Date: 2006-10-10 14:42:37
Message-ID: 452BB15D.6080100@freesurf.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi List !

I need to add a column to a view, which would contain an automatically
generated sequence.
An automatic row numbering would do the trick (I only need unique
numbers, that's all), but I don't even know how to achieve this.
Does anybody have a solution for this problem ?

Thanks a lot !
--
Arnaud

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2006-10-10 14:49:31 Re: Automatic row numbering / sequence in view ?
Previous Message AgentM 2006-10-10 14:39:10 Re: [PERFORM] Postgre 8.0 Installation - Issues