Re: [SQL] How to handle a requirement for nextval

On Tue, 19 May 1998, Jerome Knobl wrote:

> I have got the same trouble. I found a first inellegant solution. Is to
> create a function which make an increment like that :
> create function last98_20_rubriques() returns int4
>         as 'Select max(ref98_20_rubriques) as next from DB98_20_rubriques;'
> language 'sql';
> 
> But I read yesterday that I have to use e SEQUENCE like :
> 
>     create table toto (id int4 PRIMARY KEY, test varchar);
>     create sequence step1 increment 1 start 1000 minvalue 1000 maxvalue
> 999999;
> 
> And after that I have normaly to do :
>     insert into toto (id,test) values (step1.nextval,'sdf');
> But It's don't work.
> If you can go further send me a mail (and sorry for my very bad english).

insert into toto (id,test) values (nextval('step1'),'sdf');

                                                     Jose'