> Where do you get that impression? currval() refers to the last ID for the > session you are in. It's also FAQ question 4.15.3. Even better, if you > havn't used nextval() in your current session, currval() returns an error, > so you can't even get it wrong by accident.
I stand corrected. I was doing some testing of a PHP module that is called from a web form a while back and got inconsistent results with currval, I probably had a script error of some kind. -- Mike Nolan ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match