Re: Better to use a Sequence?
From: Alan Gutierrez <ajglist_at_izzy.net>
Date: Tue, 07 Jan 2003 22:00:48 GMT
Message-ID: <k6IS9.5981$t06.85570_at_news2.east.cox.net>
Date: Tue, 07 Jan 2003 22:00:48 GMT
Message-ID: <k6IS9.5981$t06.85570_at_news2.east.cox.net>
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 - 23:00:48 CET