Automatic row numbering / sequence in view ?

From: Arnaud Lesauvage <thewild(at)free(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: Automatic row numbering / sequence in view ?
Date: 2006-10-10 14:33:03
Message-ID: 452BAF1F.5040905@free.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 Bill Moran 2006-10-10 14:34:14 Re: [PERFORM] Postgre 8.0 Installation - Issues
Previous Message Rafal Pietrak 2006-10-10 14:33:02 Re: adjusting primary key