Re: [GENERAL] how to insert from sequence - Mailing list pgsql-general

From Alain TESIO
Subject Re: [GENERAL] how to insert from sequence
Date
Msg-id 19991027152233.16641.rocketmail@web308.mail.yahoo.com
Whole thread Raw
List pgsql-general
> Hi all,
>
> I need help in inserting a value from sequence.  My
> code goes like this (from Java).  I do face a syntax
> level problem.
>
> statement.execute("insert into T_name (id) values (" +
> nextval('s_name') + ")");
>
> Thanks in advance for the help.

nextval is a sql function, not java so it must be sent inside
the string to execute :

statement.execute("insert into T_name (id) values
(nextval('s_name'))");


Alain


__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com

pgsql-general by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: [GENERAL] QUERY PLAN:
Next
From: "Aaron J. Seigo"
Date:
Subject: Re: [GENERAL] FW: inheritance of functions