Re: Automatic increment

GH (grasshacker@over-yonder.net) wrote:
> I believe that it is commonly preferred to do:
> select nextval('sequence');
> insert into foo (foo_id,...) values (<nextval>, ...);


Many people do the first SELECT on a form, stuff the result in a hidden
variable, then do the INSERT in the form's handler.  This prevents the
double- (or triple-) clicking of "submit" resulting in extra database
inserts.