<font size=2 face="sans-serif">in command line sql I am populating a new
table - one of the columns is a sort order </font>
<br>
<br><font size=2 face="sans-serif">each row of this field <b><u>must</u></b>
be a 'one up' unique number starting at 1 and ending as the number of rows
in the table </font>
<br>
<br>
<br><font size=2 face="sans-serif">I know that I could do this in OpenROAD
, and in another guise this is done in OpenROAD, but in this case
it has to be done in SQL or maybe in report writer.</font>
<br>
<br><font size=2 face="sans-serif">It does not matter which rows
contain 1 ,2 etc although one of the columns does have a set of unique
numbers with gaps which could be used to determine the order of row 1,
2 etc. </font>
<br>
<br><font size=2 face="sans-serif">Does anyone know of a 'trick' to do
this?</font>
<br>
<br><font size=2 face="sans-serif">In mysql it is possible to define unique
one up numbers when creating a table does modern Ingres have this feature?</font>
<br>
<br><font size=2 face="sans-serif">thanks </font>
<br><font size=2 face="sans-serif">Allan </font><p><br>
This communication is for use by the intended recipient and contains<br>
information that may be Privileged, confidential or copyrighted under<br>
applicable law. If you are not the intended recipient, you are hereby<br>
formally notified that any use, copying or distribution of this e-mail,<br>
in whole or in part, is strictly prohibited. Please notify the sender by<br>
return e-mail and delete this e-mail from your system. Unless explicitly<br>
and conspicuously designated as "E-Contract Intended", this e-mail does<br>
not constitute a contract offer, a contract amendment, or an acceptance<br>
of a contract offer. This e-mail does not constitute a consent to the<br>
use of sender's contact information for direct marketing purposes or for<br>
transfers of data to third parties.</p>
<p>Francais Deutsch Italiano Espanol Portugues Japanese Chinese Korean</p>
<p> http://www.DuPont.com/corp/email_disclaimer.html</p>