<font size=2 face="sans-serif">Martin,</font>
<br>
<br><font size=2 face="sans-serif">Thanks for this - I don't have 10.2
documentation on my PC and the ESD site seems to be down or very busy this
afternoon so was unable to look it up.</font>
<br>
<br><font size=2 face="sans-serif">The number of times I have needed to
do this and struggled with internal procedures :-) </font>
<br>
<br><font size=2 face="sans-serif">cheers </font>
<br><font size=2 face="sans-serif">Allan</font>
<br>
<br>
<br>
<br><font size=1 color=#5f5f5f face="sans-serif">From:
</font><font size=1 face="sans-serif">Martin Bowes <martin.bowes@ndph.ox.ac.uk></font>
<br><font size=1 color=#5f5f5f face="sans-serif">To:
</font><font size=1 face="sans-serif">Allan Biggs <Allan.Biggs@GBR.dupont.com></font>
<br><font size=1 color=#5f5f5f face="sans-serif">Cc:
</font><font size=1 face="sans-serif">"info-ingres@lists.planetingres.org"
<info-ingres@lists.planetingres.org></font>
<br><font size=1 color=#5f5f5f face="sans-serif">Date:
</font><font size=1 face="sans-serif">06/02/2017 15:47</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Subject:
</font><font size=1 face="sans-serif">RE: [Info-ingres]
One up unique number for an attribute - in SQL - does anyone know the trick
of doing this?</font>
<br>
<hr noshade>
<br>
<br>
<br><font size=2 color=#004080 face="Calibri">Create the table using an
identity column or have the column take a column default which is the next
value from a sequence.</font>
<br><font size=2 color=#004080 face="Calibri"> </font>
<br><font size=2 color=#004080 face="Calibri">Martin Bowes</font>
<br><font size=2 color=#004080 face="Calibri"> </font>
<br><font size=2 face="Tahoma"><b>From:</b> Allan Biggs [</font><a href=mailto:Allan.Biggs@GBR.dupont.com><font size=2 face="Tahoma">mailto:Allan.Biggs@GBR.dupont.com</font></a><font size=2 face="Tahoma">]
<b><br>
Sent:</b> 06 February 2017 15:42<b><br>
To:</b> info-ingres@lists.planetingres.org; openroad-users@googlegroups.com<b><br>
Subject:</b> [Info-ingres] One up unique number for an attribute - in SQL
- does anyone know the trick of doing this?</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=2 face="Arial">in command line sql I am populating a new
table - one of the columns is a sort order </font><font size=3 face="Times New Roman"><br>
</font><font size=2 face="Arial"><br>
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><font size=3 face="Times New Roman">
<br>
<br>
</font><font size=2 face="Arial"><br>
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><font size=3 face="Times New Roman"> <br>
</font><font size=2 face="Arial"><br>
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><font size=3 face="Times New Roman">
<br>
</font><font size=2 face="Arial"><br>
Does anyone know of a 'trick' to do this?</font><font size=3 face="Times New Roman">
<br>
</font><font size=2 face="Arial"><br>
In mysql it is possible to define unique one up numbers when creating a
table does modern Ingres have this feature?</font><font size=3 face="Times New Roman">
<br>
</font><font size=2 face="Arial"><br>
thanks <br>
Allan </font>
<p><font size=3 face="Times New Roman"><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.</font>
<p><font size=3 face="Times New Roman">Francais Deutsch Italiano Espanol
Portugues Japanese Chinese Korean</font>
<p><font size=3 face="Times New Roman">
</font><a href=http://www.dupont.com/corp/email_disclaimer.html><font size=3 color=blue face="Times New Roman"><u>http://www.DuPont.com/corp/email_disclaimer.html</u></font></a>
<p><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>