At 09:20 AM 3/10/2008, [EMAIL PROTECTED] wrote:
Date: Mon, 10 Mar 2008 00:14:12 +
From: "Jamie Tufnell" <[EMAIL PROTECTED]>
To: pgsql-sql@postgresql.org
Subject: Re: Insert problem
Message-ID:
<[EMAIL PROTECTED]>
[snip]
> table defination
>
> create sequence schItem_item_seq
> create table
At 02:49 PM 3/10/2008, A. R. Van Hook wrote:
The following code seems to work but it leads to the following
question(s):
Is there a sequence for each scid,item or is there one sequence that
must be reset
when changing scid?
$cmd = "select setval('schItem_item_seq', (select max(item)+1 from
