Hello,

You can use the sequences, it work on Ingres 2.6 (even if it's not
documented but it might have some bugs).

create sequence toto start with 1; (or start with anything you want, see
sql.doc for options [step and so on])

update your_table
set your_column = toto.nextval;

Hope this help,
Jean-Pierre

2006/11/28, stephen.mcculloch@falkirk.gov.uk <
stephen.mcculloch@falkirk.gov.uk>:
>
> Hi all
> Is there a way to run a query which could "re-number" a field
> sequentially?
>
>
>
> Stephen B McCulloch
> Software Developer
> ----------------------------
> Corporate & Commercial Services
> ICT Infrastructure (Software Development)
> Falkirk Council,
> Municipal Buildings,
> West Bridge Street,
> Falkirk, FK1 5RS
> Scotland, UK
> ------------------------------------------
> Telephone : (01324) 501523
> Fax : (01324) 501516
> E-mail : stephen.mcculloch@falkirk.gov.uk
>
>
> ************************************************** ************************
> The information contained in this e-mail is confidential and is intended
> only for the named recipient(s). If you are not the intended recipient, you
> must not copy, distribute or take any action or reliance on it. If you have
> received this e-mail in error, please notify the sender. Any unauthorised
> disclosure of the information contained in this e-mail is strictly
> prohibited.
>
> The views and opinions expressed in this e-mail are the senders own and do
> not necessarily represent the views and opinions of Falkirk Council.
> ************************************************** ************************
>
> _______________________________________________
> Info-ingres mailing list
> Info-ingres@cariboulake.com
> http://mailman.cariboulake.com/mailm...py/info-ingres
>



--
Jean-Pierre Zuate
La Fage Conseil
+33(0)6 11 40 11 09
jpzuate@gmail.com