From: | Arnaud Lesauvage <thewild(at)freesurf(dot)fr> |
---|---|
To: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Automatic row numbering / sequence in view ? |
Date: | 2006-10-10 14:51:39 |
Message-ID: | 452BB37B.6030503@freesurf.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Merlin Moncure a écrit :
> On 10/10/06, Arnaud Lesauvage <thewild(at)freesurf(dot)fr> wrote:
>> 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 ?
>
> sure a sequence works. try this:
>
> create sequence foo;
>
> create view foobar as select *, nextval('foo') from bar;
>
> If your query is complex, i would consider it to be good style to push
> the real view into a subquery, such as:
>
> select q.*, nextval('foo') from
> (
> [complex query here]
> ) q;
>
> merlin
How, great !
I did not know that way to use a sequence ! Still learning ! ;)
The query is quite complex indeed, so I will try with a subquery !
Thanks a lot Merlin !
--
Arnaud
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2006-10-10 15:20:26 | Re: [PERFORM] Postgre 8.0 Installation - Issues |
Previous Message | Merlin Moncure | 2006-10-10 14:49:31 | Re: Automatic row numbering / sequence in view ? |