Re: SOLUTION: (was : Getting the sequence from pg to insert nexts data )

On 22/06/2003 10:58 Rodrigo F. Baroni wrote:
>
>    Hello all,
>
>       I got resolv the problem :
>
> >     I'm doing a application using jdbc to connect
> > with
> > a remote postgres database.
> >
> >     One of the tables use a sequence value. My doubt
> > is about how to get the last value of sequence to
> > put
> > in my form table index to follow the insert others
> > values.
> >
>
>       I found at list archive :
> -------------------------------------
>    "
>       First "SELECT nextval('usuario_id_usuario_seq')"
> and store that value.
> Then, "INSERT INTO USUARIO(nombre, passwd, tipo,
> correo)
>     VALUES('tania','aaaaa', $id,
> 'tanitamile@yahoo.com');" where $id is the
> value you stored before.>

That's the way I do it. The other way is to define the column as type
serial and let the database generate the default value:

INSERT INTO USUARIO(nombre, passwd, correo)
VALUES('tania','aaaaa','tanitamile@yahoo.com')
If you need to get the generated key you can do this with SELECT
currval('...') but note that this will only work reliably within the same
tranaction.

HTH


--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+