FW: SQL question, getting error and not sure why

Maybe it does in Oracle - you should check your documentation though... BTW, please post your replies to the list rather than me personally :-) > -----Original Message----- > From: Michael Sweeney [mailto:mike_sweeney@videotron.ca] > Sent: 30 May 2002 15:58 > To: Michael Davey > Subject: Re: SQL question, getting error and not sure why > > > I thought it gave you the highest record value, IE recrods > containing values > 1-10, it would return 10 > > > ----- Original Message ----- > From: "Michael Davey" <mikey@splatted.net> > Newsgroups: php.general > To: <php-general@lists.php.net> > Sent: Thursday, May 30, 2002 10:52 AM > Subject: Re: SQL question, getting error and not sure why > > > > > insert into acteursenc (nuacteur,nomacteur) > > > (select AA, BB from > > > (select max(nuacteur)+1 AA from acteursenc), > > > (select 'Michael Sweeney' BB from acteursenc))" > > > > > > produces an ORA-00001: unique constraint error. > > > > > > The primary key is nuacteur, but by setting AA to max(nuacteur)+1 I > should > > > be getting a new key that is unique, however it does not seem > that way. > > > > > > What am I doing wrong here? > > > > I'm not an Oracle expert, but surely max(field) + 1 is one > higher than the > > maximum value possible for the column? > > > > (Probably irrelevant snippet from mySQL manual: > > MAX(expr) > > Returns the minimum or maximum value of expr. MIN() and MAX() may take a > > string argument; in such cases they return the minimum or maximum string > > value.) > > > > regards, > > > > Mikey > > > > > > >