<div class="moz-cite-prefix">On 28/12/12 03:27, John Fabiani wrote:<br /></div><blockquote
cite="mid:50DC5AD0.3040507@jfcomputer.com"type="cite">Hi, <br /> I have the following statement in a function. <br
/><br/> UPDATE orderseq <br /> SET orderseq_number = (orderseq_number + 1) <br /> WHERE
(orderseq_name='InvcNumber');<br /><br /> All it does is update a single record by incrementing a value (int). <br
/><br/> But it never completes. This has to be some sort of bug. Anyone have a thought what would cause this to
occur. To my knowledge it was working and does work in other databases. <br /><br /> Johnf <br /><br /><br
/></blockquote><fontsize="-1">It might he<font size="-1">lp if you give the table definition</font></font>.<br /><br />
Definitelyimportant: is the exact version of PostgreSQL used, and the operating system.<br /><br /><br /> Cheers,<br />
Gavin