Is there any way to make a SELECT return an extra field that is a
sequential number for the tuples that are returned?
I am trying to populate a table with an INSERT SELECT and would like to
make one of the fields a sequence starting with 1 for the first tuple
and incromenting. I don't want the field to be a unique index. As the
query is run again and again I want more tuples appended to the table
and each time the counter should start at 1 and count up.
Roy Souther
www.SiliconTao.com
Let Open Source help your business move beyond.
For security this message is digitally authenticated by GnuPG.