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