Re: Sequences
От | mallah@trade-india.com |
---|---|
Тема | Re: Sequences |
Дата | |
Msg-id | 3C67E0F5.1E213068@trade-india.com обсуждение исходный текст |
Ответ на | Sequences ("Hunter, Ray" <rhunter@enterasys.com>) |
Список | 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>
В списке pgsql-sql по дате отправления: