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

From Shadkam Islam
Subject Re: [GENERAL] how to insert from sequence
Date
Msg-id Pine.LNX.3.96.991027202536.19076A-100000@trishul.wipinfo.soft.net
Whole thread Raw
In response to how to insert from sequence  (soundar rajan <psrajan@yahoo.com>)
List 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
>
> ************
>


pgsql-general by date:

Previous
From: soundar rajan
Date:
Subject: how to insert from sequence
Next
From: "Ross J. Reedstrom"
Date:
Subject: Re: [GENERAL] QUERY PLAN: