Re: SQL INSERT/TRIGGER Help - Mailing list pgsql-sql

From Alvaro Herrera
Subject Re: SQL INSERT/TRIGGER Help
Date
Msg-id 20071210140805.GD8036@alvh.no-ip.org
Whole thread Raw
In response to Re: SQL INSERT/TRIGGER Help  ("Poovendran Moodley" <poovenm@gmail.com>)
List pgsql-sql
Poovendran Moodley escribió:
> I'm not really sure how to the *currval() *method. I've read up on it and I
> noticed it works with *nextval()* and *setval()*. The parameter for *
> currval()* is a regex - is there a regex to represent the most recently
> automatically generated number ( i.e. a serial field)?

It's not a regex.  I assume you are confused because it says "regclass".
This is shorthand for "registered class" (where "class" is a synonymous
for "relation", in this case a sequence).

-- 
Alvaro Herrera                  http://www.amazon.com/gp/registry/5ZYLFMCVHXC
"La felicidad no es mañana. La felicidad es ahora"


pgsql-sql by date:

Previous
From: "Stefan Scheidegger"
Date:
Subject: Re: INSERT INTO relational tables
Next
From: Scott
Date:
Subject: Insert Rule, Multiple Insert, Update Problem