Re: [GENERAL] sequence help

2006-11-28 Thread Ragnar
On þri, 2006-11-28 at 01:12 -0800, Matthew Peter wrote: > I'll jump right in with an example > > create sequence foo start with 1; > > create view foobar as select *, nextval('foo') from bar; > > The problem is I need a nextval()-like method that returns the iterations > without > updating the

Re: [GENERAL] sequence help

2006-11-28 Thread Alban Hertroys
Matthew Peter wrote: > I'll jump right in with an example > > create sequence foo start with 1; > > create view foobar as select *, nextval('foo') from bar; > > The problem is I need a nextval()-like method that returns the iterations > without > updating the foo sequence. Therefore, maintainin

[GENERAL] sequence help

2006-11-28 Thread Matthew Peter
I'll jump right in with an example create sequence foo start with 1; create view foobar as select *, nextval('foo') from bar; The problem is I need a nextval()-like method that returns the iterations without updating the foo sequence. Therefore, maintaining the sequences original value by star

[GENERAL] Sequence Help

2001-01-17 Thread Brian C. Doyle
Hello all, How would I setup a sequence that would reflect, for example, abc-0001?