Scott Marlowe <scott.marlowe@xxxxxxxxx> writes: > On Mon, Jul 27, 2009 at 8:48 AM, Jamie > Lawrence-Jenner<jamie.jenner@xxxxxxxxxxxxx> wrote: >> Our update statements are as follows >> >> Update table set col1=x,col2=y where pkid=1; >> Update table set col1=x,col2=y where pkid=2; >> Update table set col1=x,col2=y where pkid=3; >> >> Very simple and straight forward. Sometimes there could be as many as 50 >> update statements to process. > Might as well fire them each as separate statements inside one > transaction, since pkid is unique and non-repeated in the updates. If they're all exactly the same pattern like that, it might be worth the trouble to set up a prepared statement. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
