On 10/10/06, Arnaud Lesauvage <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
