>Date: Thu, 9 Dec 1999 16:35:35 +0200
>From: "Nikolay Mijaylov" <nmmm@nmmm.nu>
>Re: [GENERAL] get the previous assigned sequence value
>Why you discuss it????
>The problem is quite clean and it was solvev many years ago.....
>1. Get the *next* sequence value:
>select nextval("gogo_seq");
>2. Store it into a variable (for example $X)
>3. Insert proper data (and and sequence value)
>insert into gogo values( $X, 'NMMM', 'mailto:nmmm@nmmm.nu');
>4. Use value $X, as u want
>insert into gogo_detail values( $X, 'bla bla0');
>insert into gogo_detail values( $X, 'bla bla1');
>insert into gogo_detail values( $X, 'bla bla2');
>Am I clear?
>nmmm
No comments...
Just imagine that the transaction aborts after you did select
nexval().
--
``````````````` Silvio Emanuel Nunes Barbosa de Macedo '''''''''''''''''''
smacedo@ic.ac.uk smacedo@inescn.pt
Imperial College, University of London INESC Porto
Intelligent and Interactive Systems Telecom. and Multimedia
Exhibition Road, Pc da Republica, 93
London SW7 2AZ, England 4050-497 PORTO PORTUGAL
Tel:+44 171 5946323 Tel:+351 22 2094220