Re: Better to use a Sequence?

Alan Gutierrez wrote:

> insert into customer_order_item (order_id, order_item_id)
> select 1, max (coalesce(order_item_id, 0)) + 1

             coalesce(max(order_item_id), 0) + 1
> from customer_order_item
> where order_id = 1;

There may be some other typos here, sorry.

Alan Gutierrez Received on Tue Jan 07 2003 - 16:00:48 CST