Re: [GENERAL] how to insert from sequence

From: Shadkam Islam <shadkam(at)wipinfo(dot)soft(dot)net>
To: soundar rajan <psrajan(at)yahoo(dot)com>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] how to insert from sequence
Date: 1999-10-27 14:56:41
Message-ID: Pine.LNX.3.96.991027202536.19076A-100000@trishul.wipinfo.soft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Try

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

Regards,
Shad.

On Wed, 27 Oct 1999, soundar rajan wrote:

> 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.
>
>
> __________________________________________________
> Do You Yahoo!?
> Bid and sell for free at http://auctions.yahoo.com
>
> ************
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ross J. Reedstrom 1999-10-27 15:09:13 Re: [GENERAL] QUERY PLAN:
Previous Message soundar rajan 1999-10-27 14:38:38 how to insert from sequence