Re: Function problems redux - Mailing list pgsql-general

From tony
Subject Re: Function problems redux
Date
Msg-id 3945515.1005057452740.JavaMail.root@localhost
Whole thread Raw
In response to Function problems redux  (tony <tony@animaproductions.com>)
List pgsql-general
You wrote:
> there is a missing ; in the line
> >INSERT INTO individu (individu_id,nom,prenom,type2) VALUES (ival, nom,
> >prenom, art)

I got that one after hitting send... sorry

Now on to todays question:

how do I get currval and nextval to work in pl/pgsql? They seem to be stuck and won't update during the session.

Cheers

Tony Grant



--
tony@animaproductions.com

JWebMail WebMail/Java v0.7.6 WWW to Mail Gateway

pgsql-general by date:

Previous
From: Chris
Date:
Subject: Re: Stored procedures
Next
From: Lincoln Yeoh
Date:
Subject: Re: data integrity