IMHO, it would be good for the last_value to come back null if is_called
is false.  Don't know if that's possible or even a good idea -- but
figured it was worth a note since the following psql log raised my eye
brow a bit. 

Wayne

-------------------------------------
policy=> create sequence a start 1;
CREATE SEQUENCE
policy=> select last_value from a;
 last_value 
------------
          1
(1 row)

policy=> select nextval('a');
 nextval 
---------
       1
(1 row)

policy=> select last_value from a;
 last_value 
------------
          1
(1 row)

policy=> select nextval('a');
 nextval 
---------
       2
(1 row)

policy=> 
--------------------------------

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to