At 1:08 AM +1000 8/26/07, T&B wrote:
When I create a view, is there any way to enumerate the output rows?
Another method would I've developed/discovered is to create a
temporary table, fill it with the data from the view, then use the
automatically created rowid column as the enumeration. This works,
but is not ideal since the creation of a temporary table can't be
included in a view itself.
If that works, then try using a subquery in the view definition instead.
create view Enumerated
as
select rowid as Sequence, Name from (
select Name from Planets order by Name
)
Sort of like that.
-- Darren Duncan
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------