Re: Sequences - Mailing list pgsql-sql

Further to Brunos' suggestion, <p>if you require to use the  same id for insertion in other tables (slaves) you should
<br/>assign the value to a variable and use that value for inserting <br />in other referencing tables eg <p> $id =
$dbh-> selectrow_array("select nextval('seq_name')");  (# perl specific) <p><font color="#000000"> <font
face="Verdana"><fontsize="-1">insert into users ( "user_id", "user_fname", "user_lname", "user_email"
)</font></font></font><br/><font color="#000000">        <font face="Verdana"><font size="-1">values ( $id , 'Ray',
'Hunter','rhunter@enterasys.com' );</font></font></font><font face="Verdana"><font color="#000000"><font
size="-1"></font></font></font><p><fontface="Verdana"><font color="#000000"><font size="-1"> insert into user_details (
"user_id", ..... other details ....  )</font></font></font><br /><font color="#000000">         <font
face="Verdana"><fontsize="-1">values ( $id ,  .... other details .... );</font></font></font><br /><font
face="Verdana"><fontcolor="#000000"><font size="-1"></font></font></font>  <br /><font color="#000000"></font>  <br /> 
<br/>  <br />  <p>"Hunter, Ray" wrote: <blockquote type="CITE">  <p><font face="Verdana"><font color="#808080"><font
size="-1">Ihave various sequences in my database set up for ids.  My question is:  How can I get the current value of
thesequence without creating a session and using the currval function?</font></font></font><p><font
face="Verdana"><fontcolor="#808080"><font size="-1">I would like to take the current value of the sequence and use it
fora value in an insert statement.</font></font></font><p><font face="Verdana"><font color="#808080"><font
size="-1">Example:</font></font></font><p>       <font face="Verdana"><font color="#808080"><font size="-1">insert into
users( "user_id", "user_fname", "user_lname", "user_email" )</font></font></font><br />        <font
face="Verdana"><fontcolor="#808080"><font size="-1">values ( 'current sequence', 'Ray', 'Hunter',
'rhunter@enterasys.com');</font></font></font><p><font face="Verdana"><font color="#808080"><font
size="-1">Thanks,</font></font></font><p><b><fontface="Verdana"><font size="-1">Ray Hunter</font></font></b><br /><font
face="Verdana"><fontsize="-1">Firmware Engineer</font></font><p><b><font face="Verdana"><font size="-1">ENTERASYS
NETWORKS</font></font></b><p><fontface="Verdana"><font size="-1">Phone:          801 887-9888</font></font><br /><font
face="Verdana"><fontsize="-1">Fax:            801 972-5789</font></font><br /><font face="Verdana"><font
size="-1">Email:         <u><font color="#0000FF"><a
href="mailto:rhunter@enterasys.com">rhunter@enterasys.com</a></font></u></font></font><br/><font face="Verdana"><font
size="-1">www:           <u><font color="#0000FF"><a
href="http://www.enterasys.com">www.enterasys.com</a></font></u></font></font></blockquote>