Re: [HACKERS] [GENERAL] Bug with sequence

"Thomas O'Connell" <tfo(at)monsterlabs(dot)com> writes:
> It seems worth pointing out, too, that some SQL purists propose not
> relying on product-specific methods of auto-incrementing.
> I.e., it is possible to do something like:
> insert into foo( col, ... )
> values( coalesce( ( select max( col ) from foo ), 0 ) + 1, ... );
> and this is easily placed in a trigger.

... but that approach is entirely unworkable if you want any concurrency
of insert operations. (Triggers are a tad product-specific, too :-()

regards, tom lane